Hi Dags,

Maybe wrap your formula like this
=MAX(your formula,0)

HTH
Martin

"Dags" wrote in message
...
In a cell that already has an IF formula in it, how do I hide any negative
answer so as to show 0:00 (time) or at least blank?