Calculate daily pay

[shell2133]

Hi everyone. I want to be able to calculate the daily pay for agency staff but their pay rate depends on the day of the week and what time they work, whether it's day or night rate. Sample spreadsheet here with the shifts worked on the first tab and all the agency information on the info tab: Agency pay - hopefully this works and has all the info needed.

Any help you can give would be much appreciated

 

[shell2133]

Hi there. No problem, just grateful for your help I have split the rates using the code. The bank holidays weren't on a separate sheet but no issue with putting them on one, whatever works best is fine. Thank you!