Without seeing your sheet it's a little confusing what is causing the #value
to appear, in the following example i'm assuming it is the subtraction. If
not, nest the ISERROR(...) check appropriately.

=IF($AF$4AF7,0,IF(ISERROR(AF7-$AF$4),0,AF7-$AF$4))

Does that help?
--
Regards,

DavidB


"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