User Profile
Mike_Geraghty
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Calculating penalty rate hours in a shift that has differing penalty rates
Dear Members, I have been working on this spreadsheet for some time. I have been kindly helped as I have proceeded, but I still have a recurring issue I cannot solve. I am a bus driver and I am attempting to check my complicated payslip as there are continual mistakeswith my pay, especiallywith a penaltyrate that is calculated based on start and end times. I have attached a full description of the problem I am tryingto solve, which can be summarised as such; If I start work before 7:00am and finish after 7:00am I am paid on a pro-rata basis those hours worked. For example I f I start work at 5:30am and finish at 1:30pm I am paid a 15% penalty rate for 1.5 hours. If I startwork before 8:00pm and finish after 8:00pm I am paid for the full shift. For example if start work at 3:00pm and finish at 11:00pm I am paid a 15% penalty rate for 8 hours. The problem I am trying to solve is to create a formula(if possible) to calculate the varyingshifttimes. As such please also find attached a spreadsheet with a range of start and end time scenarios that I hope provides the entire scheme of penalty hours that I am trying to achieve. Thank you, MichaelExcell spreadsheet for wages
I am building an excel spreadsheet for staff wages. I use a drop down list that describes the shift done, or as the case maybe, a day off. However the pay rates and associated penalty rates differ depending on the shift done. Is there a formula or function that can recognise a drop down description from my list and apply then apply relevant pay rate. Thank you
