Thread: VLookUP Problem with Time Comparision
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default VLookUP Problem with Time Comparision
Excel 2007
According to the attached test setup,
this occurs about 3.3% of the time.
A general solution might be to
MROUND to the nearest minute or second:
http://www.mediafire.com/file/zymzzv3yyol/12_28_08.xlsx
Reply With QuoteReply With Quote