Time formats in Excel

If you edit an exported CSV file in Microsoft Excel, be careful typing time entries. Excel can change the time format and the resulting entries do not work when you import the changed objects.

The import objects from CSV feature accepts two time formats:

• DAYS HH:MM:SS:SSSSSS - the number of DAYS is followed by a space.

• HH:MM:SS:SSSSSS - Excel automatically changes the entry to an incompatible format.

When you type time entries in Excel, use the following format:
DAYS HH:MM:SS:SSSSSS.

For example:
0000 01:02:12.123: 1
04:03:06.12:120
22:66:88:123456