View Single Post
  #13   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JP Ronse JP Ronse is offline
external usenet poster
 
Posts: 174
Default 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"))))