LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 4
Default Pls Help - blank cell/formula issue

I am creating a Wages, Hour and Payroll summary for my fiancé because he's trying to keep track how the new company is handling wages/time schedules, etc.

However, I'm struggling with a few calculations that I just cannot find solutions for online.

Basically my sheet is set to:
F G
10 Hours Overtime
11 Monday 8.5
12 Tuesday 8.5
13 Wednesday 9.5
14 Thursday 12.5
15 Friday 9.5
16 Saturday
17 Sunday
18 Total Wkly Hours:____ ____

The formula that I have in F-18 is as follows: =((F12-0.5)+(F13-0.5)+(F14-0.5)+(F15-0.5)+(F16-0.5)+(F17-0.5)+(F18-0.5))
It totals the hours he works then minus' his non-paid 30 min break
The problem that I am running into is:
1 - Saturday & Sunday - I want the formula to bypass these cells (F16 & F17) if they are blank

Now for the Overtime column (G11):
Basically I have this formulated to calculate his hours worked minus his non-paid break, then determine anything over the figure in F11 (formula: =(F12-8.5)
but if the F column has no figures, it is still calculated and gives the G column a negative value :/

G18 just sums the figures in the G column and gives him a weekly total of overtime that can be applied to personal and/or holidays.

The problem is, if cell F16 and/or F17 are blank they are still computing the formula, I want it to ignore what is NULL/Blank

I know my formulas aren't very complex and could probably be done much better, but I am not an expert nor every day user of Excel. I can normally make calculations do what I want them to do just by googling information but in this case.. I cant, so if someone could please help me I would greatly appreciate it.

Thank you
Sho
 
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
Counting blank cell issue DCR Excel Programming 3 February 2nd 10 02:51 PM
How to return a blank formula cell if the reference is blank? waybomb Excel Worksheet Functions 2 January 22nd 09 05:53 PM
Average Formula to display blank cell if named range is blank Rachael F Excel Worksheet Functions 3 February 22nd 08 05:05 PM
Start Cell B1 then find first blank cell, insert subtotal, next non blank, then next blank, sutotal cells in between......... [email protected][_2_] Excel Programming 2 June 7th 07 09:27 PM
Formula that will leave cell blank if cell is blank jimtmcdaniels Excel Programming 1 May 11th 06 07:26 PM


All times are GMT +1. The time now is 06:36 PM.

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

About Us

"It's about Microsoft Excel"