Hi Guys,
Here is the challenge, have this table:
09:00 Jen
10:00 Frank
11:00 Tom
12:00 Hannah
The goal is to Vlookup time in column A and return name in column B only if the time in column A is between range of +20 minutes of current time and -20 minutes of current time.
Can you help me?
Thanks to all.
Here is the challenge, have this table:
09:00 Jen
10:00 Frank
11:00 Tom
12:00 Hannah
The goal is to Vlookup time in column A and return name in column B only if the time in column A is between range of +20 minutes of current time and -20 minutes of current time.
Can you help me?
Thanks to all.