Working with times - Bug?
Thank you for your reply. I will be giving the ideas a try once I have
completed some other work on the file.
I think the L was a typo should just be K and J.
Thank you again for your time.
Regards
Anthony
"Ron Rosenfeld" wrote in message
...
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
|