how do i calculate pay from given hours and pay rates?

E

ejm014

i work in a hospital and have 3 rates of pay. One basic rate - Monday to
Friday 8 am till 8 pm. I also have a night rate from 8 pm till 8 am Monday to
Friday, which also includes from midnight friday till midnight Saturday. I
also have a Sunday rate which is from midnight Saturday till midnight Sunday.
How can i create a formula in Excel which will calculate my total gross pay,
given that i input my shift start time and finish time? I'd like it to
recognise the shift between each pay rate as the shift progresses. Hope this
makes sense? Easier to show that to explain! It is probably very easy to
someone who knows the formula's in Excel. I thought i did..... PLEASE
help.....???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Calculating Times for Pay Rates 4
Search closest day in the past from today 2
How to calculate difference between two date & time along with working hours and days 2
how do I calculate a week days hours with the 24hour clock 5
Calculate current time + 7 hours and skipping weekends 3
Construct staff pay timesheet 1
calculating pay rates for different times of the day 4

Top