Making up a Timesheet

[Steve1958]

Hi
I am trying to make up a Time sheet for work to calculate my pay.
I have most of it but I cannot work out how to apply penalty rates.
Have got the overtime rates but I get paid a penalty for doing afternoon shifts and night shift
Each having a different rate
Can't work out the correct formula to do each shift at it's correct rate.
Can anybody help??
Thanks

 

[alansidman]

Explain in simple English what you have in your worksheet and what you need specifically. You have not provided enough information to assist. What are the criteria and the values/rates associated with your issue.

 

[Steve1958]

Explain in simple English what you have in your worksheet and what you need specifically. You have not provided enough information to assist. What are the criteria and the values/rates associated with your issue.

I am thinking that Using my Shift start times are what I need to do a formula on the shifts start at 07:00 for day shift, 15:00 for afternoon shift with a 15% loading for the whole of the shift and night shift starts at 23:00 with a 20% loading. each shift is 8 hours long
The tome sheet has start and finish times and lunch break times for each day and weekend days have a X 1.5 ( If base rate was $10.00 then it would become $15.00) loading on the base rate for the day. Hope this is the information you need
Thanks