Totaling Time in Time Reports

In most cases, to Total the time within a Report, you can click the Auto-Sum button to see how many hours were worked.  But other times, Excel likes to assume it knows what you are looking for and formats the Auto-Sum value in a way that shows the wrong calculation.

Below is an example of how to correct a report so that it shows the correct Auto-Sum value.