Hi,

New Timesheet.xlsx - this is a new spreadsheet I have been working on to make calculating overtime more easy.

I think I have the first few formulas down in an easy way to calcuate the number of hours based on the start and finish time (whethere it goes into a second day or not.)

What I want to do now is have the 'Hours in Excess' column calculate the 'Total work Hours' minus the 'Break Hours' and 'Normal Work hours'.

For example if a person worked 12 'Total Work Hours' and had a 1 hour break and normally worked 8 hours the formula would be: 12-1-8=3 'Hours in Excess'

I cant seem to get it to do it though.

I think I have formatted all the cells correctly (ie: the right kind of time) but i could be wrong.

I hope someone can take a look at the attached sheet and let me know?

Thanks