Report fields regarding time display a date when exported to Excel

There are some report fields that show the time something happened, but these values appear as a date when exported to Excel. The fields display correctly as a time when displayed on screen, in PDF, or CSV.
The following fields in reports behave this way:
  • Creation Time
  • Last Modified Time
  • Creation Time
  • End Time
  • Last Modified Time
  • Start Time
  • Current Time
There are a couple different ways to display these fields as a time instead of date.
  1. Export as CSV (or PDF) instead of Excel
  2. If you must export as Excel, you can reformat the column following these steps:
    • Highlight the column
    • Right click > Format cells
    • On the Number tab, choose Time > OK

Environment

 eTapestry

Was this article helpful?