Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Date Calculation inconsistant results | Excel Programming | |||
Calculation results as static data not formula. | Excel Worksheet Functions | |||
Help please... Simple calculation - with unexpected results | Excel Worksheet Functions | |||
Calculation on SUMIF Results | Excel Worksheet Functions | |||
Save calculation results | Excel Programming |