Time Sheets

[Helen Black]

on duty off duty total time
MONDAY 07:00 16:00 09:00
TUESDAY 05:30 19:25 13:55
WEDNESDAY 06:15 17:15 11:00
THURSDAY 07:15 16:30 09:15
FRIDAY 03:00 17:00 14:00
SATURDAY 07:25 12:35 05:10
SUNDAY 00:00
WEEKLY TOTAL 62.33
I have formatted the Weekly Total as Number and the rest of the times
as hh:mm
=SUM(H7:H13)*24 this is the formula I have done for the Weekly total
when it is adding 13 minutes to my total.

Thank you for getting back to me you really are helping me. If it helps
I could see if I can manage to attach the file or if you want to send me
your e-mail address I could send it that way

 

[JulieD]

Hi Helen

62.33 is not the number of hours and minutes it's the decimal equivalent of
the number of hours ... 0.33 of an hour is 20 minutes (just as .5 of an hour
is 30 minuts)

if you want to see 62:20
then use the formula
=SUM(H7:H13)
and format it to a custom format of
[h]:mm

Cheers
JulieD