[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
<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