On 17/11/2008, Steve Kapinos <[EMAIL PROTECTED]> wrote: > Found my answer in a google search > > =(x/1000+((365*70+17)*86400))/86400 >
= x/86400000 + 25567 > I'm not quite sure why this vs just =UnixTime / 86400 + 25569 Where does 25569 come from? > But the top one seems to work > What is the Excel base? The JMeter base is the Java base which is milliseconds since midnight Jan 1, 1970 UTC. I think Unix is the same, except it uses seconds? > > -Steve > > > -----Original Message----- > From: Steve Kapinos [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2008 9:34 AM > To: JMeter Users List > Subject: timestamp field in xml result files > > I'm trying to post process some result files which were saved to xml and > having some trouble with the ts field. I assume this to be a unix > timestamp, but can't convert it successfully to a format excel likes and > can't find any additional details in jmeter.properties as per the > documentation. > > What format is this ts field stored in? > > Thx > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
