Need formula to find the difference between time and minus lunch and breaks

Hi ShellyBelly,

Please see the attached spreadsheet.

I've changed the formulas for you. I've assumed that the break/lunch is based upon the hours elapsed at work as opposed to the payable hours. e.g. If I worked 4 hrs 10 mins I'd get a 15 minute break in there. That is opposed to saying with 15 mins break I'd only work 3hrs 55mins for which I don't hit the 4 hours required for a break, etc.

One improvement is the use of a vlookup with the option of "True" or "1" at the end. This means you can have a small table show the points at which the break or lunch change rather than listing every possible combination of hours worked and the break / lunch allocated.

I hope this does what you're after; if so please mark the thread as closed under thread tools at the top and if you're happy give reputation using the "* Add Reputation" at the bottom of my post.

Cheers,

Cerbera

Overtime Tracker (reviewed).xlsx