#### sklnxbones

##### New Member

- Joined
- Jun 11, 2008

- Messages
- 26

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

*=IF($G13>"40:00",(SUM(($G13-"40:00")-SUM(H7:H12))),"")*

**NOT working**

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