Try formatting the formula cell as [h]:mm

The brackets keep the hours from rolling over into days.

8:00
8:00
8:00

=SUM(A1:A3) formatted as h:mm = 0:00. Formatted as [h]:mm = 24:00



--
Biff
Microsoft Excel MVP


"Teri" wrote in message
...
Hi all,

I run a dayhome and am trying to make my life easier on myself with my
attendance sheet but can't figure out why the formula wont work.

I am trying to get the sum of hours and minutes each child is here during
a
month so I can easily figure out what to charge the parents.

The problem I seem to be having is the total is always more than 24 hours
so
if I use the formula =SUM(D14:D20) the total only comes up as 0:00:00. I
believe I read that, that specific formula is only good when the total is
less than 24 hours.

Hopefully this is making sense, does anyone know how to make this work?

Thanks