Hours that Fall within a billing category

[Korallis]

Hi guys,
I have been strugling with this for Days.
i am at a complete loss.

basicaly i have the following

Candidate	Client	Date	Day	Start	End	Total	Break	Working	Type	Ref	Ref2
A	B	06/09/2018	Thu	19:30	07:30	12	1	11	RGN	152	45358335
B	B	06/09/2018	Thu	07:30	19:30	12	1	11	RGN	153	35534324
C		09/09/2018	Sun	19:30	07:30	12	1	11	RGN	154	3583546

<tbody>
</tbody>

above the list is a rules list

Weekday Billing
06:00 - 20:00 - Day
20:00 - 06:00 - Night
20:00 - 24:00 - Friday Night
24:00 - 24:00 - Saturday
24:00 - 24:00 - Sunday

so on a sunday night for example. untill midnight the billing is a sunday rate from 00:01 until 06:00 is night and 06:01 until 20:00 is a day rate

so i need to be able to extract the times that fall within the specified charge rate

for example

Candidate	Day	Night	Sat	Sun
A	2	10	0	0
B	12	0	0	0
C	1.5	6	0	4.5

<tbody>
</tbody>

Can anyone Help?
i have attached a sample sheet

https://icare24-my.sharepoint.com/:...FCnoKT1frGwoUBGhlcIFT7VO1pycEmVvVG8w?e=XuGX34

 

[Korallis]

Anyone that can help I cannot figure this out for love nor money

 

[Korallis]

im guessing this cannot be done then?