sklnxbones
New Member
- Joined
- Jun 11, 2008
- Messages
- 26
Ok its me again...
This is what I am trying to do...
Column F is the number of hours worked per day
Column G is the Cumulative hours worked for the week
I want Column H to figure out how many Over Time Hours (hours >40) for that day. So this is my thought process... If G13 is greater than 40, then take G13 and subtract 40, and subtract any overtime from previous days so I get the over time worked per day. BUT if NO over time is worked I want nothing to appear in column H...
This is the formula I am using... that is NOT working
=IF($G13>"40:00",(SUM(($G13-"40:00")-SUM(H7:H12))),"")
Can any one tell me whats wrong with this formula or give me a better one????
Any help would be greatly appreciated...
Thanks so much
This is what I am trying to do...
Column F is the number of hours worked per day
Column G is the Cumulative hours worked for the week
I want Column H to figure out how many Over Time Hours (hours >40) for that day. So this is my thought process... If G13 is greater than 40, then take G13 and subtract 40, and subtract any overtime from previous days so I get the over time worked per day. BUT if NO over time is worked I want nothing to appear in column H...
This is the formula I am using... that is NOT working
=IF($G13>"40:00",(SUM(($G13-"40:00")-SUM(H7:H12))),"")
Can any one tell me whats wrong with this formula or give me a better one????
Any help would be greatly appreciated...
Thanks so much