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