Excel's date/time format is described here: http://www.ozgrid.com/Excel/ExcelDateandTimes.htm
Basicly, Excel's 'clock' starts at 1,1,1900 vs the UNIX clock's 1/1/1970. 25569 is the Excel value for 00:00:00 1 Jan 1970. Excel stores times as fractions of a day...how wacky is that? J ----- Original Message ----- From: "Coret Bob" <[EMAIL PROTECTED]> To: "JMeter Users List" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, October 22, 2004 10:19 AM Subject: RE: How to convert timestamp I have found at least one way of transforming the JMeter results timestamp into a date and time using Excel. If cell A1 holds the timestamp (eg. 1098446512326) and you put the formula "=(A1+7200000)/86400000+25569" into cell B1 and change the format in "d-m-jjjj u:mm" it reads "22-10-2004 14:01". I have scraped the formula together from several sources, I can't yet explain all the numbers in the formula... Regards, Bob Coret -----Original Message----- From: Coret Bob Sent: Fri 22-10-2004 15:35 To: [EMAIL PROTECTED] Cc: Subject: How to convert timestamp The sample results contain a field called timeStamp. How (which algorithm) can I use to convert this timestamp to a format like HH:MM:SS DD-MM-YYYY ? I'd like to know the algoritm so I can make the calculation using Perl, XLST of Excel... <sampleResult threadName="Test Scenario 11-1" responseMessage="OK" timeStamp="1098442834129" dataType="text" label="00 - Startpagina" responseCode="200" time="93" success="true"/> Regards, Bob Coret --------------------------------------------------------------------- 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]
