|I'm trying to write a formula that will tell me if a given time falls between two different time ranges. The two time ranges are 10AM-2PM (Range 1) and 11PM-3AM (Range 2). I have tried the following formula from various forums, but for times after midnight, no results show for Range 2.|
B3 = 10:35:00 AM Sample time for comparison
C2 = 10:00:00 AM Range 1 (low)
D2 = 2:00:00 PM Range 1 (high)
So for example, the time for comparison is 10:35:00 AM. The above formula will generate "Range 1". However, if the time for comparison is 11:59:00 PM and C2=11:00:00 PM and D2=3:00:00 AM, the formula is true when comparing the time to C2; however, it evaluates to false when compared to D2. Why? How do I write a formula to compare the sample time to the two ranges?