Can't see any attachment...

from your previous post you say that the SUM "doesn't work"? What do you
mean. If you get 6:00 hours returned instead of 30:00 as expected then, As
david suggests, format the cell with your total hours as [h]:mm.

This format allows totals over 24 hours, h:mm format doesn't

"italiavb" wrote:

i've attached a spread sheet.
"Fred Smith" wrote in message
...
Could you give us a hint as to what formula you are using?

--
Regards,
Fred


"italiavb" wrote in message
...
Hi, I am trying to add up a column of time format (h:mm) daily totals. I
can't determine what I am doing wrong: Any help would be appreciated.
January
Day
in out TOTAL in out TOTAL DAILY TOTAL
1 6:30:00 AM 11:00:00 AM 4:30 3:30:00 PM 5:30:00 PM 2:00 6:30 6.50
2 7:00:00 AM 11:00:00 AM 4:00 2:00:00 PM 6:30:00 PM 4:30 8:30 8.50
3 8:00:00 AM 12:00:00 PM 4:00 1:30:00 PM 5:00:00 PM 3:30 7:30 7.50
4 7:00:00 AM 11:00:00 AM 4:00 1:30:00 PM 5:00:00 PM 3:30 7:30 7.50
5 0:00 0:00
6 0:00 0:00
7 0:00 0:00
8 0:00 0:00
9 0:00 0:00
10 0:00 0:00
11 0:00 0:00 $22.00 PAY
12 0:00 0:00
13 0:00 0:00
14 0:00 0:00
15 0:00 0:00

6:00 6.00 $132.00
TOTAL HRS WK CONVERSION TOTAL GROSS EARNINGS