Remember Me?

#1
January 23rd 22, 01:00 PM
 Junior Member First recorded activity by ExcelBanter: Jan 2022 Posts: 1
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

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post [email protected] Excel Programming 2 July 16th 08 01:59 PM tcidawn Excel Worksheet Functions 4 September 12th 07 05:12 PM MLK Excel Worksheet Functions 7 July 29th 06 12:03 AM Andy B Excel Worksheet Functions 3 October 9th 05 04:47 AM RC[_2_] Excel Programming 0 July 30th 03 11:56 AM

All times are GMT +1. The time now is 09:35 PM.