Hi. This is my first post so I hope I phrase my question correctly. I have a college course schedule and I need to determine if each course meeting occurs during the day (7 am to 5 pm), the evening (5 pm to 11 pm) or if it straddles the am/pm border (4 PM to 7 PM), in which case a judgment call will need to be made to determine whether it should be considered a day or evening course. I cannot seem to construct a conditional formula that can identify which courses occur in that indeterminate time zone (I'm new to IF formulas). I've gotten as far as a formula that returns a correct value for pure day courses and pure evening courses, but it puts every course that crosses the 5 PM barrier into the evening category.

=IF($C$2:$C$13<$H$2,"Day",IF($C$2:$C$13>=$H$4,"Evening"))

Below is a sample of the kind of course times I'm dealing with. I've tried using AND and Or in the formulas but I just can't figure it out. Any help the forum could provide would be very, very appreciated. Thanks! Jean

Course Start Time Course End Time Course End Time
1 8:00 AM 6:00 PM Evening Day < 5:00 PM
2 8:10 AM 4:30 PM Day Check > 4:00 PM < 7:00 PM
3 2:00 PM 6:00 PM Evening Evening >= 5:00 PM
4 5:30 PM 9:00 PM Evening
5 8:00 AM 4:15 PM Evening
6 3:00 PM 4:30 PM Day
7 9:00 AM 2:00 PM Day
8 7:15 AM 9:30 PM Evening
9 8:00 AM 4:30 PM Day
10 3:00 PM 4:30 PM Day
11 9:00 AM 2:00 PM Day
12 4:30 PM 6:30 PM Evening