View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default Working with times - Bug?

On Sun, 16 Aug 2009 08:07:45 -0400, Ron Rosenfeld
wrote:

I'd wonder if you could get
acceptable results merely by comparing the .Text property of the two cells,
instead of the .Value property. That should work so long as you only need to
test for equality at the level of whole minutes.


One further note:

If you go with this method, for robustness, in your code, you probably should
explicitly set the .NumberFormat property of the cells being compared to
"[h]:mm".

This might better be done to the relevant group of cells at one step, than
doing it at each step of the loop.
--ron