On Oct 11, 10:20*am, Mike H wrote:
Debbie,

your trying to sum text values, try this

=IF(H46="s",TIME(2,0,0),IF(H46="CLOSED",TIME(0,0,0 ),IF(H46="A",TIME(2,0,0),*I46-H46)))

Format this and the sum cell as [h]:mm

Mike



"Debbie" wrote:
On Oct 11, 9:47 am, Debbie wrote:
I have formulas in 5 columns that give me the total hours a child is
in daycare. The formula calulates the total time according to there
sign in and out times. That works great. But when I sum those
formulas, it says "0". What am I doing wrong?

=SUM(B47:K47)

This is the formula I have that calculates the time in attendance if
this helps. Those results are what I am trying to sum.

=IF(H46="s","2:00",IF(H46="CLOSED","0:00",IF(H46=" A","2:00",TEXT(I46-
H46,"h:mm"))))- Hide quoted text -

- Show quoted text -

Thank you! This worked. You guys are great!