Shift Premium On Payroll Calculator

Hello,

I've been toying with this spreadsheet for a couple of years, and now that I'm back working in the factory I actually make enough money to be interested in my income again.... HaHa

My next project in this is stop having to manually compute shift premium. With the swing shifts, I work at several shift premiums based on starting time. I do work at different premiums in the same week so I need to be able to differentiate different days from each other. An additional wrinkle is that after crossing 40 hours in a week I begin earning overtime, which also multiplies the shift premium.

I'm trying to find a way to either "categorize?" an individual shift as a certain premium for that day, or (hopefully not) use a system of start time instead of simply entering total hours worked. And then I need excel to multiply the premium only after 40 hours in that given week, which may actually happen in the middle of a shift.