How to Format an Excel File to Display Date and Time

Third Party Applications and Services
When exporting an Excel file from the Tracking page of the OnTime Customer Web Portal, the time portion of date columns will transfer with the export. However, Excel may default to showing the date only. To view both the date and time, you may need to format the cells in Excel.
Follow these steps in Excel to format the cells:
  1. Open the exported file in Excel and right-click on the column header of the date and time column.
  2. Select Format Cells from the right-click menu.
  3. Under the Category options pane choose Time.
  4. Scroll down the selections and choose the format you prefer. Near the bottom of the list, you should see formatting options that allow you to display both the date and time together.
  5. Click OK to save your changes.
Article ID: 96, , Modified: September 16, 2019 at 3:24 PM

Share this article