Time Formatting

B

brianwakin

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.
 
R

Ray A

Format>Cells>Custom>hh:mm:ss

brianwakin said:
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.
Click to expand...
 
R

Ron Rosenfeld

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

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
 
D

Dave Peterson

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.
 
Top