Microsoft Excel Tips and Tricks
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.
Credit Chester Tugwell