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.

We would need the specifics about when the shift premium applies and how it is calculated. You can avoid entering starting times if you are willing to indicate which shift premium applies to each each. I am assuming a given shift premium applies to all hours in that shift, and you are only working one shift per day. I have not done shift work but depending on your policy or union agreements you may get a premium for afternoons, another premium for graveyard, so we have to double the day rows to indicate whether a premium applies to each day. It looks like you get paid OT for over 40 but not for Saturdays or Sundays. How is pay for holidays treated? How are you calculating the row labelled "Shift Pay"?

By the way, I have to say that you are doing an enormous amount of work to do something that your company payroll system already does for you. I do budgeting for myself, and I just enter the data from each pay stub instead of trying to calculate it myself. The information comes a week after the pay period closes but that's when the money comes available.

Also I couldn't help but notice you have a couple of weird spikes in your power bill in February '14 and '15.