If functions with Two different time ranges

[sultan5533]

Hello,

I'm trying to create if function to test if an value falls in one of the two time ranges. For that endded up with the followin function but it did not work.

IF(OR(AND(D1>=StartTime1, D1>=EndTime1), OR(D1>=StartTime2, D1>=EndTime2)), "Yes", "No")

Could anyone tell me what I'm missing.

Thank you

[JohnTopley]

Try

=IF(OR(AND(D1>=StartTime1, D1<=EndTime1), OR(D1>=StartTime2, D1<=EndTime2)), "Yes", "No")

[Jonmo1]

I think you need to reverse the 2nd > in each AND

AND(D1>=StartTime1, D1>=EndTime1)
Should probably be
AND(D1>=StartTime1, D1<=EndTime1)

[Jonmo1]

And your 2nd OR should be an AND

Try
IF(OR(AND(D1>=StartTime1, D1<=EndTime1), AND(D1>=StartTime2, D1<=EndTime2)), "Yes", "No")

[sultan5533]

Thank you all, that worked

[Jonmo1]

You're welcome.