Ladies & Gents...Boys and Girls - Cats and Dogs, hope your all well!

I need some assistance please.

[Caveat] - My excel skills are rubbish when it comes to mathematics [Caveat /]

Based on certain times i work i get Time/time*1.5/time*2

So...

Example:

Saturday
Working from 12:00pm - 23:59 (11:59 Hours)

Between 8 and 5 its normal time.
Between 17:00:01 - 21:00 its Time*1.5
After 21:00 - 08:00 the following day its Time*2

How can i automate this?

Columns:
a1 - Date
b1 - Day
c1- Start Time [hh:mm]
d1- End Time [hh:mm]
e1 - Break
e1 - Total Hours (=SUM(D2-C2)-E2) ?
f1 - Overall Time (Automated to include overtime)

Too complicated? Is this possible?

=IF(AND(OR may be required?

Many thanks in Advance..

If you talk bad about country music, it's like saying bad things about my momma. Them's fightin' words.
Dolly Parton