Try the below formula. If the formula produces the #Value error only the
result will be 0. Otherwise the result will be whatever it is, even if it is
another type of error.

=IF(NOT(ISERROR(IF($AF$4AF7,0,AF7-$AF$4))),IF($AF$4AF7,0,AF7-$AF$4),IF(ERROR.TYPE(IF($AF$4AF7,0,AF7-$AF$4))=3,0,IF($AF$4AF7,0,AF7-$AF$4)))

Hope this helps.

Bill Horton

"Conditional Formatting" wrote:

I have a time formula.
=IF($AF$4AF7,0,AF7-$AF$4)

Can you help me fina a way when the result is #value it must turn to zero.

Thanks in advance