Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formatting in Excel 2003
How can I format a cell in Excel 2003 using 12-hour format but without
displaying AM/PM? For example, for 1:00 in the afternoon (1:00 PM or 13:00), I would like to display just " 1:00 " (without the quotation marks); not " 1:00 PM "; not " 13:00 ". Is there a way to format the cell(s) to display time in this way? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formatting in Excel 2003
I don't think it's possible using a numberformat alone.
Can you use a different cell and a formula? =LEFT(TEXT(A1,"hh:mm AM/PM"),5) (with leading 0's.) akg wrote: How can I format a cell in Excel 2003 using 12-hour format but without displaying AM/PM? For example, for 1:00 in the afternoon (1:00 PM or 13:00), I would like to display just " 1:00 " (without the quotation marks); not " 1:00 PM "; not " 13:00 ". Is there a way to format the cell(s) to display time in this way? -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time formatting in Excel 2003
Works like a charm! Perfect!
Thank you Dave. --akg "Dave Peterson" wrote: I don't think it's possible using a numberformat alone. Can you use a different cell and a formula? =LEFT(TEXT(A1,"hh:mm AM/PM"),5) (with leading 0's.) akg wrote: How can I format a cell in Excel 2003 using 12-hour format but without displaying AM/PM? For example, for 1:00 in the afternoon (1:00 PM or 13:00), I would like to display just " 1:00 " (without the quotation marks); not " 1:00 PM "; not " 13:00 ". Is there a way to format the cell(s) to display time in this way? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 Time Calculation | Excel Worksheet Functions | |||
excel 2003 formatting | Excel Discussion (Misc queries) | |||
How can I "RANK" time in Excel 2003? | Excel Worksheet Functions | |||
Rounding time in excel (2003) | Excel Discussion (Misc queries) |