Help with results of calculation
Hi all,
I am self taught and learning daily. I have set this formula up to calculate overtime for my staff. how can I get it to show as blank if the result is 0? I have tried for 4 hours using IF etc but without suceess.
=(((G5-F5)*24) -8)& " Hours Overtime"
F5 is the start time, G5 is the finish time and 8 is the number of hours before overtime is active.
It currently says '0 hours overtime' but I would rathe it be blank to make it obvious.
Thank you for any help I receive
|