Hi Ron!

So my theory is that this is a rounding issue and that
you may have, perhaps inadvertently, done two partial
fills when you initially populated the range. And doing
the second fill is what got stuff screwed up.

Ron, you're a genius!

That's what I did but it was intentional. I drag filled I
don't know how many cells and then later I extended the
list by selecting and dragging the last filled cell.

That would also explain why I could not reproduce the
behavior because when I tried I only did a single drag
operation.

Good stuff!

Thanks for your time.

Biff

-----Original Message-----
On Sun, 13 Mar 2005 12:22:16 -0800, "Biff"
wrote:

Full version:

Excel 2002(10.6501.6735) SP3

I think Sandy is correct, however, after I cleared the
cell and manually entered the value 23:00, it still is
not
working.

Want to see the file? It's small, only 17kb.

I fooled around with your file, and with a new workbook.

I started off by entering 6:00 in H1 and filling down to
H19. I did the same
thing in Column I. In J1: =H1=I1 and filled down to I19.

Initially, all showed TRUE, as expected.

However, I then selected, for example, I14 (containing
19:00) and dragged it
down to I19. Several of the TRUE's changed to FALSE's.
What changed would
depend on where I started.

So my theory is that this is a rounding issue and that
you may have, perhaps
inadvertently, done two partial fills when you initially
populated the range.
And doing the second fill is what got stuff screwed up.

You may be able to avoid this by using a formula instead
of the auto-fill
method (e.g. =TIME(HOUR(H1)+1,0,0) but that will wrap to
0 at midnight, instead
of to "1" as the fill would do.


--ron
.