That is not true, your way would use and extra cell and that is not what the
OP asked for. However if you are using an extra cell then this is somewhat
easier

=--TEXT(E1,"00\:00")

format the cell as h:mm AM/PM

or format directly as text

=TEXT(TEXT(E1,"00\:00"),"h:mm AM/PM")


--


Regards,


Peo Sjoblom


"muddan madhu" wrote in message
...
try this ...suppose u enter 1635 in A1 , put this formula in B1
=TIME(LEFT(A1,2),RIGHT(A1,2),0)


On May 31, 4:29 pm, "MartinW" wrote:
Hi Kim,

Chip Pearson has a way
here,http://www.cpearson.com/excel/DateTimeEntry.htm

HTH
Martin

"kimrich" wrote in message

...



In a spreadsheet, how can I quickly enter 3 or 4 time numbers and have
excel
convert those numbers to a standard time AM or PM format?- Hide quoted
text -

- Show quoted text -