Page 146
6. Click Close, then OK.
Formatting the Excel .csv file for milliseconds
Excel does not have a standard number format for milliseconds. It can be added using
the custom formatting.
1. Select the top timestamp in your spreadsheet.
2. Right click the cell and select Format Cells
3. Under Number, select Custom
4. The format should present hh:mm:ss.0
5. Add two extra 0’s so it looks like this: hh:mm:ss.000
6. Copy this format to all cells in this column
To Next Page
Loading...