On Dec 8, 12:23*pm, Gord Dibben wrote:
If A1 is 10:30 in cell and formula bar, that would indicate you
have text, not a real time.

Second scenario also sounds like text.

I suspect you are correct about the cell containing text at least in
the first case.

But in the second example, how could text show "as 01:30 in the cell.
In the formula bar it shows as 01:30:00"?

My suspicion: Dave is being sloppy in his description.

I suspect the cell is formatted as Custom hh:mm. In Dave's first
example, the time is entered as text, as you conjecture. But in the
second example, the time is entered as numeric, and Dave neglected to
say that PM appears in the Formula Bar.

That crossed my mind........no AM or PM mention but is there.


Gord

On Wed, 8 Dec 2010 15:02:49 -0800 (PST), joeu2004 wrote:

I suspect the cell is formatted as Custom hh:mm. In Dave's first
example, the time is entered as text, as you conjecture. But in the
second example, the time is entered as numeric, and Dave neglected to
say that PM appears in the Formula Bar.