- Why does my exception report show exceptions that have a duration of 0 while having a distance greater than 0
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.
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.