Thread: Excel Question #46
View Single Post
Old 02-16-2012, 03:10 PM   #9
Moonliner
8/30/14 - Disneyland -10k or Bust.
 
Moonliner's Avatar
 
Join Date: Jan 2005
Posts: 9,022
Moonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of coolMoonliner is the epitome of cool
Send a message via AIM to Moonliner Send a message via MSN to Moonliner Send a message via Yahoo to Moonliner
Quote:
Originally Posted by Betty View Post
I have a spreadsheet I got online and tweaked a bit for my husband to help him calculate overtime hours. Unfortunately it's not working right and now is not the time for this to be happening. ARGH! (It is SO one of those days - starting last night with the dead battery, continuing with today's flat tire and now this. While I won't go into details - the timing of this couldn't be worse.)

I'm hoping one of you excel-lent excel-lers will be able to look at it and go - add this and "ta-da" it works.

Here is a link to screen shots: https://picasaweb.google.com/1106550...JHNsqmhrKD1Kg#

Or I could send the file if that's easier.

It should be showing overtime on saturday if M through S has 8 hours. It's not though.
For starters, Monday is in column 'B' but the formula starts in column 'C'. Update your SUM function. (Note 'SUM' appears twice in the first image.)
__________________
- Taking it one step at a time.
Moonliner is offline   Submit to Quotes Reply With Quote