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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Candidate
[/TD]
[TD]Client
[/TD]
[TD]Date
[/TD]
[TD]Day
[/TD]
[TD]Start
[/TD]
[TD]End
[/TD]
[TD]Total[/TD]
[TD]Break
[/TD]
[TD]Working
[/TD]
[TD]Type
[/TD]
[TD]Ref
[/TD]
[TD]Ref2
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]B
[/TD]
[TD]06/09/2018
[/TD]
[TD]Thu
[/TD]
[TD]19:30
[/TD]
[TD]07:30
[/TD]
[TD]12
[/TD]
[TD]1
[/TD]
[TD]11
[/TD]
[TD]RGN
[/TD]
[TD]152
[/TD]
[TD]45358335
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]B
[/TD]
[TD]06/09/2018
[/TD]
[TD]Thu
[/TD]
[TD]07:30
[/TD]
[TD]19:30
[/TD]
[TD]12
[/TD]
[TD]1
[/TD]
[TD]11
[/TD]
[TD]RGN
[/TD]
[TD]153[/TD]
[TD]35534324
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD][/TD]
[TD]09/09/2018
[/TD]
[TD]Sun
[/TD]
[TD]19:30
[/TD]
[TD]07:30
[/TD]
[TD]12
[/TD]
[TD]1
[/TD]
[TD]11
[/TD]
[TD]RGN
[/TD]
[TD]154
[/TD]
[TD]3583546
[/TD]
[/TR]
</tbody>[/TABLE]


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

[TABLE="width: 500"]
<tbody>[TR]
[TD]Candidate
[/TD]
[TD]Day
[/TD]
[TD]Night
[/TD]
[TD]Sat
[/TD]
[TD]Sun
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]2
[/TD]
[TD]10
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]12
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[TD]0
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]1.5
[/TD]
[TD]6
[/TD]
[TD]0
[/TD]
[TD]4.5
[/TD]
[/TR]
</tbody>[/TABLE]


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?