K
Kim.P
Hi All,
Am here to see if someone can help me with a problem I am having with a
work excel spreadsheet.
I do the shift work pays, and use excel to work out how many hours o
each shift each person works. We are just about to change the workin
hours of the night shift that currently work from 12 midnight to 8am t
11pm to 7am. So a 7.5 hour shift per night.
My issue is that if a person starts work at 11pm they are paid one hou
afternoon shift allowance until 12pm then 6.5 hours at night shift rate
So I need to be able to split the 7.5 hours worked in 5 different cell
(eg working week is Wednesday thru to Tuessday) into 2 other cells tha
are all added up together to give me a total of hours that the perso
needs to be paid. eg normal hours, afternoon shift allowance and nigh
shift allowance.
Can this be done
Am here to see if someone can help me with a problem I am having with a
work excel spreadsheet.
I do the shift work pays, and use excel to work out how many hours o
each shift each person works. We are just about to change the workin
hours of the night shift that currently work from 12 midnight to 8am t
11pm to 7am. So a 7.5 hour shift per night.
My issue is that if a person starts work at 11pm they are paid one hou
afternoon shift allowance until 12pm then 6.5 hours at night shift rate
So I need to be able to split the 7.5 hours worked in 5 different cell
(eg working week is Wednesday thru to Tuessday) into 2 other cells tha
are all added up together to give me a total of hours that the perso
needs to be paid. eg normal hours, afternoon shift allowance and nigh
shift allowance.
Can this be done