Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
How to type format time in decimal format & calculate time | Excel Discussion (Misc queries) | |||
Conditional Format (exclude 0) | Excel Discussion (Misc queries) | |||
How to exclude weekends/holidays from plotted time series | Charts and Charting in Excel |