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 Wrote:
Hi Helen

can you type out an example of when it's rounding as i've not noticed
this
when i've used this method

cheers
JulieD

"Helen Black" wrote in
message ...-

When I am doing the formula =SUM(H7:H15)*24 on my time sheet and
setting
the total to numbers so that it gives me the correct totals the
formula
is making my sheet go out I think it is rounding the totals up with
having to multiply by 24 to get the sheet working right.

Can any one help me get this right as I cannot have my sheet rounding
up by as much as 13 minutes on some times.

Helen


--
Helen Black-


--
Helen Black