View Single Post
  #1   Report Post  
Stephen Wilcox Stephen Wilcox is offline
Junior Member
 
Posts: 1
Default 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