Time working registration sheet

Hi guys,

I'm trying to create timesheet for my blue collar employees.
Already create an have basic as attached but I'm struggling a little with specific formulas.
I would like to create formula which will count night working hours between 21:00 till 05:00, tried few formulas from interned but non was working correctly as there was no explanation how to modify it other conditions.

And second one would be formula to count 50% and 100% overtimes, but salary system in my company is quiet complicated and it would loos like that :
Working hours from 05:00 till 21:00 , 50% overtimes are counted over 8 hours from Monday to Saturday and on Sundays and holidays all working hours are counted as 100% overtimes.
Overtimes from 21:00 till 05:00 are same as night working hours and are counted 100% from Monday to Saturday.

It' possible to connect it somehow in one formula or two ?Formatka testowa.xlsx

To count hours that span midnight try this formula;

(f your times are in A1 and B1)

= B1-A1+(B1<A1). Multiply this cell by 24 to get the actual number of hours.

It looks like you know the day worked, so you should be able to use the above formula (and maybe a couple of nested IFs) to determine how much is 50% or 100% overtime rated.