If Time is Within Range

Looking for formula to look into column D and column E to return "In Range" if Time is within range and Out of Range if Time of not within range using the Time Range Condition in J1 and K1. See attached sample file.

Desired Outcome is in column F.

Thanks

You can use this formula in cell F2:

=IF(E2<D2,"Out of Range","In Range")

then copy down as required. It gives different results from your sample file on rows 94 and 113, so just check those again.

Hope this helps.

Pete

Well, the range is from 0:00:00 to 23:59:00 which is virtually a complete day, so I presumed the OP wanted to check for times which wrap around midnight, based on the formula in column G, and the range becomes irrelevant.

Pete

Another option:

=IF(AND(A2+D2>=A2+$J$1,G2+E2<=A2+$K$1),"In Range","Out of Range")

This assumes that your "time range" is for the same day. You can change your Time Range to any time frame and it should still work. You do have some records though where your Sales Time IN is later than your Sales Time OUT for the same day, which doesn't make sense to me (row 94 for example).

Gregb11: Row 94 and 113 were erroneously entered as In Range instead of Out of Range. Thanks for the rep, Gregb11.

Isn't the TIME erroneously entered, not whether it was in or out of range? How can you have your OUT time before your In time on the same day (or is the OUT DATE erroneously entered)?

Gregb11 : Time was not erroneously entered. The sales rep started her shift at 7:20PM on 12/19/2022 and finished on 12/20/2022 at 7:30AM. Thus, Out of Range.

Thanks

"(or is the OUT DATE erroneously entered)?"
Then this is true