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

If I understand correctly, try this:

=IF(MAX([@Total2],[@Début])-MIN([@Total2],[@Début])=0,"",TEXT(MAX([@Total2],[@Début])-MIN([@Total2],[@Début]),"-H::MM"))

Out of curiosity, why are you using the TEXT function?

That worked great, thanks :-)

I have used this formula as it is the only way I could get the results to show negative results when using time formulas.

Unfortunately, my equation still does not work, please see the attached image.

It is calculating the negative hours OK, but it is showing the positive variations as negative? I have marked the cells which should be positives in yellow.

I have tried the basic Total2 - Total but this does not show the negative results.

Any help would be great.

Attached Images

Calculating hours.jpg (189.2 KB, 17 views)

See the attached.

Attached Files

1904_Date_System.xlsx (293.4 KB, 9 views)

Yes, this worked perfectly. Thanks very much