Hi Everyone,
Need help with sample sheet attached.
Have got the formula to cost each shift sorted, just having trouble being able to add a allowance that occurs Mon. to Fri. before 7am and after 7pm.

It is highlighted in green.

Thanks to anyone that can help.