Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2021/07/If-Time-is-Within-Range.xlsx

In this video I demonstrate how to do the following:

1) Perform an IF statement that returns a value if a time is before, after or equal to another time.

2) Perform a nested IF or IFS statement to find if a time is within a time range and return a corresponding value.

3) Perform a lookup using VLOOKUP or XLOOKUP to find a time within a time range and return a corresponding value.
------------------------