Adding IF in nested formulas
Hi,
I have a formula calculating number of hours as follows:
=TEXT(MAX([@Total2],[@Début])-MIN([@Total2],[@Début]),"-H::MM")
I would like to add an If statement, saying that if cell ## returns a result of 0:00 (hrs) then leave the cell blank.
How do I add this into the existing formula?
Thanks
Caz
|