Exclude AM/PM from time format

[flawed]

Help please!

I want to append the date and time to a file name, which
is easy enough, but the trouble is, I want the time to
appear in "AM/PM" format and not show the "AM" or "PM".

The only way I know of to do this is to use a format like:

Format(Now(), "YYYY MM DD HH MM SS AM/PM")

I don't want the "AM" or "PM" to appear. Is there another
way to format the time as "AM/PM" so it doesn't show, or
do I need to crop those characters off using something
like the "Left" function?

I prefer a corrected format method, but I don't know what
it would be.

Your example code would be most helpful. Thanks in advance.

 

[Cesar Zapata]

I tried the code and excluded the AM/PM and it worked for me.


Cesar Zapata

 

[Ron de Bruin]

Hi

Not much experience with this so I choose for the left function

Try this

Dim Str As String
Str = Format(Now(), "YYYY MM DD HH MM SS AM/PM")
ActiveWorkbook.SaveAs Left(Str, Len(Str) - 3)

 

[Ron de Bruin]

The hour is different Cesar (20 and 08)