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

**DoreenBassett** · 02-20-2009, 08:45 AM

Hello

I really need some help!!! I'm battling to come up with the formula to calculate time and a half and double time. My boss wants me to show the overtime worked AFTER 40 hours has been worked.

I have attached a copy of my spreadsheet and would greatly appreciate any suggestions.

Many thanks
DB

**johncassell** · 02-20-2009, 11:18 AM

Hi Doreen,
am I right in assuming that you pay 40 hours minimum and anything over that is considered overtime?

**johncassell** · 02-20-2009, 12:41 PM

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

**DoreenBassett** · 02-23-2009, 07:29 AM

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

**DoreenBassett** · 02-23-2009, 08:10 AM

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