If A1 is 10:30 in cell and formula bar, that would indicate you have text, not a
real time.

If a real time in A1, formula bar should read 10:30:00 AM or PM

Second scenario also sounds like text.

Real time of 01:30 in a cell would be cutom formatted and the formula bar would
read 1:30:00 AM

The formula bar would never have 01:30:00 for any real time.

Test these times by entering in B1 =ISNUMBER(A1) then copy down.

TRUE or FALSE


Gord Dibben MS Excel MVP


On Wed, 8 Dec 2010 19:43:10 -0000, "xcel__" wrote:

Hi

Column A has cells with times before 12:00 noon. 10:30 in the cell shows as
10:30 in the formula bar

after 12:00 noon, shows as 01:30 in the cell. In the formula bar it shows as
01:30:00

How can I make before noon times to show as 10:30:00

This is so I can sort by times.Morning first, then afternoon and then night

Thanks inadvance

Dave