Calculating Day Night hours distribution

Greetings fellow Excel lovers,

I'm facing a bit of a conundrum - trying to split shift durations between Day and Night hours, where the night hours are between 22:00 and 06:00 and the output should be in numerical form. The hours I need to be split in two columns - Day hours (all hours in the range of > 06:00 and <= 22:00) and Night hours (> 22:00, <=6:00).

Attached are some simulations of what hours can be seen and what is the desired outcome.

So far I've created a If formula with 7 different conditions, but I'm confident there is a smarter way to do it, I just feel stuck with this.

PS: I searched in the other topics, but couldn't find exactly what I needed, so I'm hoping somebody can help.