Need Formula for Timeband

[JeysJeys]

[TABLE="width: 623"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Telecast Date[/TD]
[TD]Telecast Day[/TD]
[TD]Day[/TD]
[TD]Start Time[/TD]
[TD]End Time[/TD]
[TD]Time Zone[/TD]
[TD]Answer[/TD]
[/TR]
[TR]
[TD]1-Aug-19[/TD]
[TD]Thursday[/TD]
[TD]Weekday[/TD]
[TD="align: right"]7:00:00[/TD]
[TD="align: right"]12:00:00[/TD]
[TD]Morning[/TD]
[TD]
Prime Time




[/TD]
[/TR]
</tbody>[/TABLE]
i need Timeband Name in answer format

Weekday
starting 07 to 13-PT
Starting 17-21-PT
Rest- NPT

Weekend- All NPT

 

[Peter_SSs]

Duplicate to https://www.mrexcel.com/forum/excel-questions/1106229-need-formula-timeband-name-answer-column-per-below-details.html

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.