RE: How to convert timestamp

2004-10-22 Thread Chuck Henson
: joelsherriff [mailto:[EMAIL PROTECTED] Sent: Friday, October 22, 2004 1:19 PM To: JMeter Users List; [EMAIL PROTECTED] Subject: Re: How to convert timestamp I just tried it and to me it looks like that 720 is some kind of local adjustment for timezone and/or daylight savings time. (720 is

Re: How to convert timestamp

2004-10-22 Thread joelsherriff
terious 720 from the > equation. > I'm baffled, any suggestions? > Thanks, Chuck > > -Original Message- > From: Coret Bob [mailto:[EMAIL PROTECTED] > Sent: Friday, October 22, 2004 9:20 AM > To: JMeter Users List; [EMAIL PROTECTED] > Subject: RE: How to convert

RE: How to convert timestamp

2004-10-22 Thread Chuck Henson
ter Users List; [EMAIL PROTECTED] 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+720)/8640+25569" i

Re: How to convert timestamp

2004-10-22 Thread sebb
"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 JMet

Re: How to convert timestamp

2004-10-22 Thread joelsherriff
y...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

RE: How to convert timestamp

2004-10-22 Thread Coret Bob
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+720)/8640+25569" into cell B1 and change the format in "d-m- u:mm" it reads "22-10-2004 1