Timesheet with overtime calculation between certain hours, days only

I need a simple time sheet which calculates as follows each day

A input arrival time e.g. 07:15
B input leaving time e.g. 21:30
C to calculate hours at the three rates payable,

PR Plain rate between 08:00 and 17:00
SHO (Social hours overtime) (time and a half) between 06:00 and 08:00 and between 17:00 and 21:00
ASHO antisocial hours overtime (double time) any other times e.g. midnight to 06:00 and 21:00 to midnight.

can anyone help me to construct a formula to show the hours of each category for a day from 7:15 to 21:30 i.e. 9 hours at plain rate (08:00 to 17:00), 4 hours 45 mins social hours overtime (07:15 to 08:00 and 17:00 to 21:00) plus 30 mins at antisocial hours overtime rate.(21:00 to 21:30)

Many thanks
Excel Novice in Hexham

Pl see the attached file.
Mark the thread Solved if it is ok.

Thank you so much for creating the example for me. The formulas are more complicated than anything I have used before - I can only do the very basic calculations.
Would you be able to add one further tweak? The hours 0800 to 1700 are at standard rate but include a one hour unpaid lunch. it can be taken at any time but is not logged on the time sheet by the engineer. would it be easy to just take one hour off the total hours for the plain rate on the spreadsheet ?

Pl see the file attached.
Formula changed.

Perfect, thank you so much. I have marked the thread as solved (I hope!) A novice at this forum as well as at Excel so fingers crossed I've done that right.

hi,
I have a similar problem, but the shift can begin at 1900 and end at 0700 the next day. The solution given to the original query doesn't seem to allow for the shift to run past midnight into the next day.
We have 3 different payscales during the 24hrs
Standard Rate runs from 0700 to 1900
Evening Rate runs from 1900 to midnight
Night Rate runs from midnight to 0700
The shifts are 0700 - 1900 and 1900 - 0700, so the night shift has evening rate up to midnight then night rate until 0700
Can anyone help please?