Exclude AM/PM from time format

  • Thread starter Thread starter flawed
  • Start date Start date
F

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