Is there any way to format time to AM/PM without displaying AM/PM? Thanks.
--
Brian

Try the 24 hour clock
Formatcellstime13:30

"brianwakin" wrote:

Is there any way to format time to AM/PM without displaying AM/PM? Thanks.
--
Brian

The time needs to be displayed in a 12 hour clock format without the "AM or
PM" actually being displayed. Is there any way to do this? Thanks again.
--
Brian


"Ray A" wrote:

Try the 24 hour clock
Formatcellstime13:30

"brianwakin" wrote:

Is there any way to format time to AM/PM without displaying AM/PM? Thanks.
--
Brian

FormatCellsCustomhh:mm:ss

"brianwakin" wrote:

The time needs to be displayed in a 12 hour clock format without the "AM or
PM" actually being displayed. Is there any way to do this? Thanks again.
--
Brian


"Ray A" wrote:

Try the 24 hour clock
Formatcellstime13:30

"brianwakin" wrote:

Is there any way to format time to AM/PM without displaying AM/PM? Thanks.
--
Brian

On Tue, 13 Sep 2005 14:32:57 -0700, "brianwakin"
wrote:

Is there any way to format time to AM/PM without displaying AM/PM? Thanks.

Not if it is to remain a time that Excel will recognize as such.

In other words, there is no way to display 4:00 as 4PM and have Excel recognize
it as being 4PM.

But you could display it in a different cell.

For example:

=TEXT(MOD(A1,TIME(12,,)),"h:mm")


--ron

Another way if you show two digits for both hours and minutes:

=LEFT(TEXT(A1,"HH:MM AM/PM"),5)

If you only show one digit, you have to be more careful and can't just use the
first 5 characters.


brianwakin wrote:

Is there any way to format time to AM/PM without displaying AM/PM? Thanks.
--
Brian

--

Dave Peterson