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 click 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: