Still relatively new to advanced functions in excel. I work in a machine shop that runs 24/7. I'm trying to create a by-weekly time card calculator for multiple shifts/pay rates with OT after 40 hours/week. I'm also calculating hours using the 7 minute rule. I have things figured out for rounding time with the 7 minute rule, calculating hours per day and figuring pay rates with shift premiums and OT pay. I have a column of cells noted 1 or 2 depending on my shift for the day. What I can't seem to figure out is how to total the hours to get straight pay for each shift then OT for each shift after 40 total hours. I work 12 or more hours per shift both days and nights bouncing from one to the other during the week.
Example:
Sun 5pm-6am
Mon 5pm-6am
Tue 5:30 pm-7am
Wed 6pm-6am
Thur off
Fri 5:30am-6pm
Sat 6am-6pm
totals should be
40 nights
11.5 nights OT
0 days
24.5 day OT
for a total of 76 hours overall
I just can't figure out how to get there.
Any help would be awesome.
Thanks in advance
Bookmarks