J
jjhmbh
We have discovered a problem in referencing time using the LOOKU
function and I haven't been able to resolve it using VLOOKUP or th
INDEX and MATCH combination
The easiest way to demonstrate the problem is to creat a list of time
from 10:00 am to 12:00 pm in 15 minute increments, then copy the lis
into the adjacent column and convert that list into the decima
equivalent. See below for what the list should look like. I expande
the decimals to the maximum number of decimals.
10:00 0.416666666666667
10:15 0.427083333333333
10:30 0.437500000000000
10:45 0.447916666666667
11:00 0.458333333333333
11:15 0.468750000000000
11:30 0.479166666666667
11:45 0.489583333333333
12:00 0.500000000000000
Now if you write a formula using LOOKUP or VLOOKUP to try to return th
decimal equivalent of a time in the left column. It works fine excep
at a few times like 10:45 and 11:30 when it returns the values fo
10:30 and 11:15 respectively.
Any help would be appreciated.
Jef
function and I haven't been able to resolve it using VLOOKUP or th
INDEX and MATCH combination
The easiest way to demonstrate the problem is to creat a list of time
from 10:00 am to 12:00 pm in 15 minute increments, then copy the lis
into the adjacent column and convert that list into the decima
equivalent. See below for what the list should look like. I expande
the decimals to the maximum number of decimals.
10:00 0.416666666666667
10:15 0.427083333333333
10:30 0.437500000000000
10:45 0.447916666666667
11:00 0.458333333333333
11:15 0.468750000000000
11:30 0.479166666666667
11:45 0.489583333333333
12:00 0.500000000000000
Now if you write a formula using LOOKUP or VLOOKUP to try to return th
decimal equivalent of a time in the left column. It works fine excep
at a few times like 10:45 and 11:30 when it returns the values fo
10:30 and 11:15 respectively.
Any help would be appreciated.
Jef