Summing a Formula
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 -
The sign in and out times are formated as time h:mm AM/PM
H46: 3:00 PM I46: 5:10 PM
Then the formula I have to give the difference between the 2 times to
get the total hours attended is:
=IF(H46="s","2.00",IF(H46="CLOSED","0.00",IF(H46=" A","2.00",TEXT(I46-
H46,"h:mm"))))
My answer is Total Hours: 2.10 (2 hours, 10 min)
Then my third formula must sum the total hours attended.
The formula you gave me does not work. It just shows the formula in
cell.
|