CA Overtime Calcultions

Hello all,

First time forum user, and first time serious spreadsheet maker; the coincidence!

Okay, the rules of CA overtime:

Overtime (1.5x) for hours worked after 8 hours per day and up to and including 12 hours per day,
Double time (2.0x) for hours worked after 12 hours per day, and
Overtime for hours worked after 40 straight time hours per week, and
Applying 7th day rules, on the seventh consecutive day of work in a single work week (even if 40hrs was not met), we calculate Overtime for the first 8 hours worked, and Double time for any additional hours more than 8 on the 7th day.

I have attached the sheet I have created. Im sure I have inconsistent or wrong formulas other places, but the above is what is really important. The problems I run in to, besides being math are:

1) Overtime is redundant when counted daily, then weekly as a total.

2) Once 40 hrs is hit, I need any hours after to be Overtime. So if someone works 40hrs in 4 days doing four, 10hr days, they get Overtime for 2 hours a day, plus then they need to get overtime for any hours worked the following days of the week. Perhaps 5th day of 8 hours, and it is all overtime.

I know I got carried away with this whole thing, but I figured myself or anyone could use this in the future, and once dialed in, can be confident everyone is getting paid their fare share.

FYI:
It is in Military time, and for speed, the colon isn't necessary to type.

CA-Payroll-Send to forum.xls

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread in CS subforum.

Thread Closed.