How to See Time Entries in a Correct Format in Ad-Hoc BMS Reports?

Question: When I create an Ad-Hoc Report using the "Time Entries" table, the "Start" and "End Time" format are seen as Date in the output instead of Time.

Resolution: This is happening because the cells for the time entries have not been set to indicate that this should be in time format.

Steps:

  1. Select the column for the "Start/End Time".
  2. Right click > Format > Date > choose any of the time formats. Note: If this is on an Express Report, click on the format icon:

3. Run the report - this should now show the entries in time format.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Contact us