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