The Bulk AIP Import tool accepts both total seconds (SSSSS.00) and timestamp (HH:MM:SS.00) formats in the start_position column. By default, the export template uses total seconds. Here are tips for formatting the start_position column in your CSV.
Format a timestamp as HH:MM:SS.00 in Google Sheets
- Highlight the cell(s) with the timestamp you want to correct.
- Go to Format → Number → Custom date and time.
- In the top formatting field, select:
Hour (01):Minute (01):Second (01).Millisecond (01).
Format a timestamp as HH:MM:SS.00 in Excel
- Highlight the cell(s) with the timestamp you want to correct.
- Right-click and select Format Cells, or go to Format → Cells...
- Select Custom from the Category list.
- Type
hh.mm.ss.00into the Type field and select OK.
Convert total seconds into HH:MM:SS.00
- Highlight the cell(s) with total seconds you want to change.
- Divide the cell by 86400.
- If needed, format the cell to HH:MM:SS.00 as shown above.
Convert HH:MM:SS.00 into total seconds
- Highlight the cell(s) with the timestamp you want to change.
- Multiply the cell by 86400.
- In Google Sheets: go to Format → Number → Number.
- In Excel: right-click and select Format Cells (or Format → Cells...), then select General from the category list.
See also: Using the Bulk AIP Update Feature · How do I edit the Bulk AIP template?