Hi there!
To show a blank cell instead of "0 hours overtime" when the result is 0, you can use the
function in combination with the formula you already have.
Here's how you can modify your formula:
Code:
=IF(((G5-F5)*24)-8=0,"",((G5-F5)*24)-8&" Hours Overtime")
Let me explain what this formula does:
- The
function checks whether the result of your original formula (i.e. ((G5-F5)*24)-8) is equal to 0.
- If it is, the formula returns an empty string (""). This means that the cell will be blank.
- If the result is not 0, the formula returns the original result with " Hours Overtime" added to the end.
So, if the result of your original formula is 0, the cell will be blank. If the result is anything other than 0, the cell will display the number of hours overtime.
I hope this helps! Let me know if you have any other questions.