Aug 29 2020 05:32 AM
Hi,
I want to use vertical lookup on time values.
I have a matrix with in the first Collum date and time and in the second Collum a value.
But the normal vert.lookup function does not work.
Is there a solution?
Tnx in advance
Aug 29 2020 07:04 AM
@Lei_Nacken What exactly are you trying to lookup, and how? For instance, the date/time for "29/08/2020 15:46:11" is stored in Excel as the number 44072.6570717593000 The time portion alone, i.e. "15:46:11" equals the number 0.657071759259259.
You may have to split the time and date column first, then round the time 10 digits in order to be able to lookup the time value only.
Aug 30 2020 02:00 AM
@Riny_van_Eekelen
Hi
Thank you so much for your answer. You sent me in the right direction. I solved my problem.