Hello,
I am having some trouble with the way to calculate the weekly wage basing on the hours worked with different rates of pay at different time of the day.
Basically what I want is to enter my duties start and finishing times for the whole week (sunday to saturday) so that it calculates my income for the week basing on the hours including.
However we have different rates of pay depending on the day and the time of the day
Lets say :
Basic rate of pay : 11
---
Friday rate of pay: 11
Friday evening rate of pay(8pm - 12am) : 12
Friday night rate of pay(12am - 4am): 13
---
This obvieously goes on for saturday and sunday but lets keep its simple, one formula will be enough help for me.
Now lets say I start my work at 6pm(18:00) and finish at 10pm(22:00)
This gives me 4 hours of work of which 2 hours are at $11 and 4 hours are at $12.
The easy way would be to calculate how much hours and minutes I have worked at basic rate and times that by the rate and same again with the hours and minutes worked at higher rate. However this can be done using pen and paper but I want excell to do it without me having to enter the hours and minutes for different rates.
Please help it would be very useful and helpful..
Thankyou :*
Bookmarks