Forum Discussion
help with a formula comparing a time to two different time ranges
I'm working on a speed study for school zones. I have the list of speeds and their associated times throughout the day. I know that the school zones are active during two different time ranges: 7am - 8:30am and then 2:26pm - 3:26pm.
I'd like a formula that tells me "Yes" if the associated time falls between one of the two different time ranges, and "No" if it's outside the two ranges.
I've been playing around with various IF statements with OR but just can't seem to figure it out.
1 Reply
=IF(OR(AND(D1>=$A$2,D1<=$A$3),AND(D1>=$A$4,D1<=$A$5)),"yes","no")
You can try this formula for the sample data.
