Calculating Time and a Half and Double Time (After 40 hours)

Hi Doreen,

try the attached sheet. It is quite different from your layout but I think yours may be over complicated.

Have a look at it and let me know what you think.

John

Thank you so much for your suggestion. I'm going to have a look at it and will get back to you.

Thanks once again.
Doreen

Hi John

Your suggestion makes alot of sense but I have a couple more questions.

Firstly, Our technicians sometimes work in the evening through to the early hours of the following morning, e.g. Overtime starts at 06:45 p.m. (8 Jan) and finished at 02:00 a.m. (9 Jan). Then they start work again during normal working hours at 08:00 a.m. on 9 Jan. How would I show that on the spreadsheet? Thats why I thought putting the different start and end columns for both overtime and normal hours would be easier.

Secondly, what formula would I use to show how many hours haven't been worked to meet the 40 hour minimum. My boss' want the spreadsheet to show the hours "underworked" and owing to the company in one column and the overtime, if any, in another column.

Thank you for you help.
Doreen