Page History

...

Once the data is in Excel, I convert the timestamp column from Jmeter's Unix timestamp format (base year 1970) to the Excel format (base year 1900 or 1904 depending on the Excel version and underlying OS) using this following formula. This formula is applied to the entire timestamp column.

For GMT time on Windows

=((x/1000)/86400)+((365*70+17)*86400))/86400
DATEVALUE("1-1-1970") - DATEVALUE("1-1-1900"))

For GMT time on Mac OS XFor local time (replace t with your current offset from GMT)

=((x/1000)/86400)+(DATEVALUE("1-1-1970") - DATEVALUE("1-1-1904"))

For local time on Windows (replace t with your current offset from GMT)

=(((x/1000)-(4*3600))/86400)+(DATEVALUE("1-1-1970") - DATEVALUE("1-1-1900"))

For local time on Mac OS X (replace t with your current offset from GMT)

=(((x/1000)-(4*3600))/86400)+(DATEVALUE("1-1-1970") - DATEVALUE("1-1-1904"))(t * 3600)+((365*70+17)*86400))/86400

3. Now sort rows on the operation name (i.e. JMeter sampler name)

...