Basic Excel Spreadsheet - Urgent

I am in need of a spreadsheet that can work out pay for staff, using the information below. I would like 3 separate tabs, one for each group.

Staff are paid hourly, but pay varies depending on what time of day they work and how long for.


Group A working from 06:00 to 21:00 earn £30.00 per hour, and earn £45.00 per hour when they work between 21:00 - 06:00.

Their shifts will often cross over those times, for example:

Example shifts/pay: 14:00 to 21:30 = £232.50; 22:00 to 03:00 = £225.00; 19:00 to 02:00 = £285.00


This is the same scenario for two other roles.
Group B is paid £25.00 per hour between 06:00 - 21:00, and £35.00 per hour from 21:00 - 06:00

Group C is paid £20.00 per hour between 06:00 - 21:00, and £30.00 per hour from 21:00 - 06:00