Summing a Formula
Hi Debbie,
Try with timevalue() instead of string formatted time:
"02:00" = timevalue("02:00")
I see a second issue, you try to 'sum' strings with I46-H46.
Wkr,
JP
"Debbie" wrote in message
...
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"))))
|