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: 7a...
=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.