Time doesn't add up correctly

[Larryg]

Greetings...
I an using Minutes: DateDiff("n", [StartDateTime], [EndDateTime]) in my query, and =[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00") in an unbound control on my report.
The time per record looks correct but the =Sum[Minutes] \ 60 & Format([Minutes] Mod 60, "\:00") calculation looks off.
For instance, one group displays the time in the individual records as follows:
0:15
0:25
2:30
0:20


That totals 210 minutes, however, the calculated Sum is showing 3:15. Seems to me it should be showing 3:30, or if fractional 3.5.
Another example is: 2:00, 1:30, 0:05 and the Sum is showing 3:00.

Can someone help me understand this?

Thanks...

Larry

[pbaldy]

What is your actual formula, as that would error? You would need to sum both instances of the minutes field.

[June7]

Can't use Format() function to directly convert decimal hours to hh:mm. Review:
http://bytes.com/topic/access/answer...e-regular-time
https://www.accessforums.net/access/...ort-33806.html