Time sheet total hours not adding up

[Jinxx]

ok we have this time sheet set up and it works fin till we get to a subtotla
for the hours worked


DAYS IN BREAK BREAK LUNCH LUNCH BREAK BREAK OUT TOTAL TOTAL
START END START END START END BREAKS HOURS
Wed.16:53 19:01 19:12 20:20 20:48 0:00 0:00 1:00
0:39 7:28
Thur.16:56 19:26 20:41 21:51 22:19 0:00 0:00 1:00
1:43 6:21
Fri. 16:56 19:56 20:14 21:47 22:15 0:30 0:47 1:00
1:03 7:01
Sat. 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00
0:00 0:00
Sun. 0:00 0:00 0:00 0:00 0:00 0:00 0:00 0:00
0:00 0:00
Mon. 16:50 0:00 0:00 0:00 0:00 0:00 0:00 1:00
1:00 7:10
Tue. 0:00 0:00 0:00 0:00 0:00 0:00 0:00 1:00
0:00 1:00 Total Time 5:00
the formula for the sub total is =SUM(L11:L23)
this is what the time sheet looks like please if you can help at all it
would be great thanks
Jinxx

 

[JoAnn Paules]

I would suggest visiting one of these excellent sites on calculating time in
Excel.

http://www.cpearson.com/excel/datearith.htm
http://www.contextures.com/xlfaqDat.html#AddTime
http://www.exceltip.com/exceltips.php?view=category&ID=111

--

JoAnn Paules
MVP Microsoft [Publisher]

~~~~~
How to ask a question
http://support.microsoft.com/KB/555375