Problems With Report Adding Total Time

Can someone please help. In my query I have a field called Total Time to show me the time differenct between Start Time and End Time The field reads: Total Time:Format ([Start Time]-1-[End Time],"Short Time"). The calculation works great. When I try to create the report and do a sum of the Total Time =Sum ([Total Time]) I get "The Microsoft Jet database engine could not execute the SQL statement because it contains a filed that has an invalid data type. If I use just ([Total Time]) it only picks up one figure out of say 20. Just for curiousity I used =Count ([Total Time]) and it gives a correct answer. So, what formulation do I use to have the Total Time column add up to the number of hours and minutes. Can someone please send me the correct way to write this? PLEASE!!!!

I am not sure where you were trying to put your Sum of Total Time on your report. But a couple of tips for you. You can't place a calculated control in the footer of a report. So what you have to do is create a text box to perform the calculation in either a group footer or detail section depending on your report design. Then set the property to not visible and then put a text box in the footer that has its control source set to the calculated text box.

The formula to add your time would be

=Format(Sum([Total Time]),"Short Time")

See if this helps
lwells