My exception report shows a duration of 0:00 for an exception however the distance is greater than 0

Related Questions

  • Why does my exception report show exceptions that have a duration of 0 while having a distance greater than 0

Applies To

  • Reports
  • Exceptions

Answer

The format of the cells in excel shows the duration in hours and minutes (hh:mm). If an exception lasts less than one minute, it will appear on the report as 0:00.

Thus, the vehicle has driven the distance during this small duration period. 

Additional Notes

You can change the format of the cells to show hours, minutes and seconds (hh:mm:ss) and upload the report as a custom report. 

To change the format of the cells, see this website for more information. 

See How To Add a Report to the Database? for more information about uploading reports.