Adding Totals in report (1 Viewer)

[aframpt]

I have a report that is run from a query. I want to add a total field at the end of the report that sums a total amount of time. The time field is in short time format. I tried using the Sum[time], but it's not working.
Any help would be appreciated.

 

[Simon]

What error message do you see?

#name?

 

[aframpt]

Actually, not an error. It comes back with a time, like 1:30 (short format). This means 1 hour and 30 minutes. I know this can't possible be the total. I want it to calculate total number of hours and minutes.

 

[Simon]

Does this error only occur when you are calculating time differences between two days?

 

[aframpt]

I wasn't trying to get total time between two dates. I needed a total "amount" of time from all records in a table. I figured another way to do it. I re-formated the field to a general number field and had people enter the time in minutes only. Then in the report, I can do a Sum and divide by 60. That gave me a more accurate "total amount of time". Hope that's not too confusing. Thanks for your help.

 

[Simon]

Glad to see that you've solved it! I think I mis-read your post slightly - sorry.