Forum Discussion
Match function in excel is only working partly
I am using Match function in excel to match individual time value with a time array, however the function is only working partly, meaning for several first data is correct but the rest ones are not w...
Hello
Time values may look identical but being decimal numbers they always bear the problem of a floating-point error.
This is one possible workaround:
{=MATCH(INT(B133)+TIME(HOUR(B133),MINUTE(B133),SECOND(B133)),INT($C$6:$C$16)+TIME(HOUR($C$6:$C$16),MINUTE($C$6:$C$16),SECOND($C$6:$C$16)),0)}