Hello first time here!
I need help on summing these time in Access (2000 format) Report.
I realized when i used the wizard to upload the data from query to report, the report doesn't even give me to Summary option on all fields with this Time (HH:MM:SS) format.
The original data from table are actually in seconds; I converted them into hh:mm:ss in query; Unfortunately these time cannot be "Sum" in the report.
I tried this one but it's not working.
=Format(Sum([Time]/3600),"00") & ":" & Format(Sum([Time] Mod 3600)/60 Mod 60,"00") & ":" & Format(Sum([Time] Mod 60) Mod 60,"00")
Time4:49:054:35:055:13:055:51:064:26:046:28:067:06:076:52:070:33:014:26:040:00:006:28:064:33:052:03:024:46:056:14:066:50:07
Can somebody please help? My boss needs to see details with summary so I need to use the report.
Thanks!!
Grace