Sorting time range between customized periods

[oreng]

Hi there, I need your support in developing formula that can sort hours by pre set periods of the day as follows (now done manually) :
Thanks

 

[kvsrinivasamurthy]

In D2 copied to full range.

=MEDIAN(INDEX($L$1:$L$4,MATCH(D$1,$J$1:$J$4,0)),INDEX($K$1:$K$4,MATCH(D$1,$J$1:$J$4,0)),$B2+IF($B2<$A2,1,0))-MEDIAN(INDEX($L$1:$L$4,MATCH(D$1,$J$1:$J$4,0)),INDEX($K$1:$K$4,MATCH(D$1,$J$1:$J$4,0)),$A2)

start	end	duration	peak-AM	Peak-PM	Off peak	Night			peak-AM	06:00​	10:00​
08:00​	22:00​	14:00​	02:00​	04:00​	05:00​	03:00​			Off peak	10:00​	15:00​
08:00​	10:00​	02:00​	02:00​	00:00​	00:00​	00:00​			Peak-PM	15:00​	19:00​
									Night	19:00​	30:00​

 

[oreng]

Thanks