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