Thread: Find time
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Find time

Excel's Edit, Find function compares the find string to the actual contents
of the cells. The actual contents of the cell may be different than the
value of the cell as it is displayed due to formatting. If you select the
cell that displays "20:30" and look at the formula bar you will see what is
actually in the cell. This is the value you must do your Find with. In my
case it is "8:30:00 PM", however if you have different Windows Regional
Settings you may see something different.

--
Jim Rech
Excel MVP