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?

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

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?