View Single Post
 
Old 03-28-2017, 08:14 AM
caz46 caz46 is offline Windows 8 Office 2013
Advanced Beginner
 
Join Date: Feb 2011
Posts: 73
caz46 is on a distinguished road
Default 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
Reply With Quote