LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Calculation inconsistant results [email protected] Excel Programming 2 July 16th 08 01:59 PM
Calculation results as static data not formula. tcidawn Excel Worksheet Functions 4 September 12th 07 05:12 PM
Help please... Simple calculation - with unexpected results MLK Excel Worksheet Functions 7 July 29th 06 12:03 AM
Calculation on SUMIF Results Andy B Excel Worksheet Functions 3 October 9th 05 04:47 AM
Save calculation results RC[_2_] Excel Programming 0 July 30th 03 11:56 AM

All times are GMT +1. The time now is 02:55 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"