According to http://office.microsoft.com/en-us/excel/HP052006741033.aspx?pid=CH010004931033 Excel uses a base of Jan 1, 1900 and counts DAYS not seconds using a real number.
>> I'm not quite sure why this vs just =UnixTime / 86400 + 25569 >Where does 25569 come from? Saw it here - and on many other pages http://excel.tips.net/Pages/T002051_Converting_UNIX_DateTime_Stamps.html But that didn't work.. the more complex one did.. -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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
