Converting a Timestamp in Excel
Some time-based parameters in CSV exports might show as a long number (Unix timestamp) rather than a readable time format. To convert this into an HH:MM:SS format, please follow the steps below:
- Copy this formula: "=(((Cell Name With Timestamp/60)/60/24)+DATE(1970,1,1))", then press the Enter key.
- Then right click on the cell that contained the formula and select Format Cell.
- Select Time and choose the desired time format.
- The time will now show in a readable HH:MM:SS time format and can easily be applied to the remaining cells by dragging the formula down.