Seperate simple hours, holiday hours and night hours

Hi,
First I would like to congratulate everyone for the help you are offering…
I have a little bit of a situation here…
As you can see on the example i have TEST hours.xlsx, I have a file that calculate the money every doctor should take based on the working hours.
Nights, holidays and holiday night have different price/hour.
The excel is working fine…but now I have to make a formula that separates automatically based on the beginning time and the end time of the doctor’s shift the day hours tha night hours, the holiday hours and the holiday nights hours.
In the excel I have fill the hours Manuscript, I need a formula to do that for me…
Is it possible to help me???
On the yellow cell I have try to find out the formula for the holiday hours but because the day is calculated due to a formula it is not working!!!

Simple Example: A doctor Is working from 21:00- 8:00 (next morning Sunday) he should have 1 simple hour (21:00-22:00) 9 night hours (22:00-6:00) and 2 holiday hours (6:00-8:00,)

Thank you in advance…

TEST hours 1.xlsx
I have manage to make the formula i found on a previous thread to wokr for day and night hours, but steel i have problem with holiday hours...

Can you please help me???