1

Why the values of two identical times are different from each other, unable to use vlookup due to this

Note: Times are taken from two different sources, one is generated as CSV from a website and the other was manually entered.

Example:

Time Values 10:00 AM 0.416666666666666 10:00 AM 0.416666666666667 FALSE

How to Solve this ? Thanks in advance.

player0
  • 124,011
  • 12
  • 67
  • 124
Raghul
  • 57
  • 1
  • 8

1 Answers1

1

this happens due to a "rounding error" more on that here: https://stackoverflow.com/a/72230592/5632629

in your case, you just need to trim/round it 12-digit decimal:

enter image description here

player0
  • 124,011
  • 12
  • 67
  • 124