Need Formula for Timeband Name in Answer Column as per Below Details

[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
2-Aug-19	Friday	Weekday	17:00:00	21:00:00	Evening
3-Aug-19	Saturday	Weekend	13:00:00	16:00:00	ROS
4-Aug-19	Sunday	Weekend	18:00:00	23:00:00	Evening
5-Aug-19	Monday	Weekday	8:00:00	11:00:00	Morning
6-Aug-19	Tuesday	Weekend	18:00:00	21:00:00	Evening
	Weekday	0700 AM -1300 PM	Prime Time
		1700 PM - 2100 PM	Prime Time
		Rest Timeband	NON Prime Time
	Weekend	All Timeband	Non Prime Time

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

 

[tyija1995]

Hey just a couple of questions,
what answer do you expect to see when the start time is within prime hours but the end time isn't? and vice versa when the start time is not in prime time but the end time is? (for weekdays)


Try this in G2: Assuming data is in columns A through F with header row in row 1.

IF(AND(AND(C2="Weekday",OR(AND(D2>=7/24,D2<=13/24),AND(D2>=17/24,D2<=21/24))),OR(AND(E2<=13/24,E2>=7/24),AND(E2<=21/24,E2>=17/24))),"Prime Time","Non Prime Time")