| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I enter 1635 and see 4:35 PM in the cell?
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 - |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Vlookup if #N/A then enter enter data in cell I4 | Excel Discussion (Misc queries) | |||
| Enter multiple numbers in a cell so total shows when enter keypres | Excel Worksheet Functions | |||
| Auto enter date when data in enter in another cell | Excel Worksheet Functions | |||
| How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
| how do I enter a RETURN (Enter) in a cell in EXCEL2003 | Excel Discussion (Misc queries) | |||
Threaded Mode
