Hi All,

Am here to see if someone can help me with a problem I am having with an work excel spreadsheet.

I do the shift work pays, and use excel to work out how many hours of each shift each person works. We are just about to change the working hours of the night shift that currently work from 12 midnight to 8am to 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 hour 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 cells (eg working week is Wednesday thru to Tuessday) into 2 other cells that are all added up together to give me a total of hours that the person needs to be paid. eg normal hours, afternoon shift allowance and night shift allowance.

Can this be done?

Hi

Yes it can be done, but far easier to show you how if you provide us with an example workbook. Make sure it contains no personal data.