Calculated "0" as an amount in Average function

[Kimberly Peters]

My formula is  =IF(F5-G4<0,"0"), this "0" result is part of an Average range. How do I format the "0" to calculate as a number within the range?

Example:

0:10:45

0:33:11

0

0

0

1:22:47

=AVERAGE(above range) which returns 0:42:14 in the HH:MM:SS format but is not calculating the zero as a number in the range. 

Can anyone tell me what I am doing wrong.  Thank you

[#2]

Hi Kimberly,

Why don't you return zero as a number?

[#3]

Hi. I tried that but the average comes back the same.  

[#4]

It shall be different, AVERAGE ignores any text

Perhaps something is with formatting. May you attach simple sample file?