Adding Time on a Report

[darlaj5]

I am one step away from completing this data base and I'm stuck. I have pulled [TOTAL TIME] per school for each field trip to a report from a Query. The [TOTAL TIME] is an espression field based off the diff from [START TIME] AND [END TIME]. So the report looks like:

Date # Total Time
School #1 4/4/2014 Trip 1 413



Subtotal 6:53 CORRECT



School #2 4/5/2014 Trip 2 374
4/7/2014 Trip 3 363
Subtotal 12:03 SHOULD BE 12:17

=Sum([TOTAL TIME])/60 & Format([TOTAL TIME]Mod 60, "\:00") in the Subtotal Property Sheet, Data, Control Source and it is giving me the correct # of hours but it appears for minutes its just dropping the number from last entry when its asked to add. Trip 1 is correct but when adding trip 2 and three the total hours are correct but its not calculating the remainder in minutes.

Can someone please help me I would really appreciate it. Thank you.

[June7]

Try:

=Sum([TOTAL TIME])/60 & Format(Sum([TOTAL TIME]) Mod 60, "\:00")

However, still don't think that is what you need. Maybe:

=Int(Sum([TOTAL TIME])/60) & Format(Sum([TOTAL TIME]) Mod 60, "\:00")

[darlaj5]

YES YES YES, thank you so much I have been trying to figure that out for weeks. =Int worked I really appreciate your help.