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]
