I have a report that list total hours worked per day. Does anyone know how to calculate the sum of hours workked. The automatic total feature only allows my count record and count value. Count Value gives me 00:00 everytime and I should be getting 57.65 (57h 39m) total hours worked.

Hrs Worked
07:07
10:04
10:18
10:05
09:57
10:08

I looked at a number of previous posts and they all refer to calcuating clockin/clock out times and getting daily total hours.

Any suggestions???? Thanks in advance :)

cant you use sum?

No, it does not work - it gives me a error.

Yeah sorry i dont know why I thought thta would work at all

Here is what ive come up with

using this

http://www.access-programmers.co.uk/forums/showthread.php?t=142257

Convert your time to minutes

=CLng(24*60*CDate([time]))
Then using this http://bytes.com/topic/access/answers/200219-convert-minutes-hour-minute-ms-access-2000-a

Convert it back to hours and minutes

=[timefield]\60 & Format([timefield] Mod 60,"\:00")


I used a running sum on the times in the report and used that total as the timefield

It worked ... It worked :) I don't know what I would do without you all.

I owe you BIG time, Thanks

By the way, this is what I did

I created a new field [text31] on the side hidden =CLng(24*60*CDate([time])) then created a total field under the daily entered hours =([text31]\60)

The report looks perfect and only I know all the hidden stuff.