Sum of Hours Worked (1 Viewer)

CCFL

Registered User.
Local time
Today, 11:40
Joined
Apr 23, 2010
Messages
19
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 :)
 

CCFL

Registered User.
Local time
Today, 11:40
Joined
Apr 23, 2010
Messages
19
No, it does not work - it gives me a error.
 

rainman89

I cant find the any key..
Local time
Today, 11:40
Joined
Feb 12, 2007
Messages
3,016
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
Code:
=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
Code:
=[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
 

CCFL

Registered User.
Local time
Today, 11:40
Joined
Apr 23, 2010
Messages
19
It worked ... It worked :) I don't know what I would do without you all.

I owe you BIG time, Thanks
 

CCFL

Registered User.
Local time
Today, 11:40
Joined
Apr 23, 2010
Messages
19
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.
 

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

Top Bottom