Need Formula for Timeband

[JeysJeys]

Telecast Date	Telecast Day	Day	Start Time	End Time	Time Zone	Answer
1-Aug-19	Thursday	Weekday	7:00:00	12:00:00	Morning	Prime Time

<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

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.