...
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) using this following formula. This formula is applied to the entire timestamp column. (NOTE: a better formula was mentioned on JMeter users list sometime back
For GMT time
| No Format |
|---|
=(x/1000+((365*70+17)*86400))/86400
|
For local time (replace t with your current offset from GMT)
| No Format |
|---|
=(x/1000+(t * 3600)+((365*70+17)*86400))/86400
|
...