In my reports, why sometimes does the Total Hours not equal the sum of each line?

It's a rounding effect: each punch duration (or line) is rounded to the nearest minute, but the total is the sum of each unrounded punch and only rounded afterward. As a simple example, in format MM:SS, if there were three punches, 01:41 (one minute, forty-one seconds) and 01:36 and 01:01, they would each be rounded to 02:00 and 02:00 and 01:00. If you sum the unrounded numbers, it's 04:18, and then if you rounded that, it's 04:00. But if you add each rounded number, it's 05:00. So the total is actually more accurate, then summing each line.

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request


Powered by Zendesk