N.B. the timestamps are in milliseconds, and by default are the time of the END of the sample - this can be changed in jmeter.properties.
Instead of creating a fraction, you can convert to a character-based version of the time using Perl's localtime() and sprintf, e.g. sprintf "%d-%s-%04d %02d:%02d:%02d",$mday,$mons[$mon],$year,$hour,$min,$sec; where @mons=qw(Jan Feb etc). S. On Fri, 22 Oct 2004 10:37:34 -0400, joelsherriff <[EMAIL PROTECTED]> wrote: > 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] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
