now() Date and Time Formatting

G

Guest

How do I get "mm\/dd\/yyyy hh\:nn\:ss" to show the date and time (with AM/PM)
in not 24 hour time?

Thanks!
Adam
 
F

fredg

How do I get "mm\/dd\/yyyy hh\:nn\:ss" to show the date and time (with AM/PM)
in not 24 hour time?

Thanks!
Adam
Click to expand...

Format(Now(),"mm/dd/yyyy hh:nn:ss AM/PM")
09/22/2006 01:30:22 PM

Format(Now(),"m/d/yyyy h:nn:ss AM/PM")
9/22/2006 1:29:43 PM
 
G

Guest

That was quick, thanks!

fredg said:
Format(Now(),"mm/dd/yyyy hh:nn:ss AM/PM")
09/22/2006 01:30:22 PM

Format(Now(),"m/d/yyyy h:nn:ss AM/PM")
9/22/2006 1:29:43 PM
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert a date 4
Trouble with Date Formats 4
Conditional formatting will not work with Now() 3
Computing Elapsed Time 4
Summarizing Date and Time 2
Change format to mm dd yyyy hh mm ss 1
Extracting just the time portion 5
Excel macro to open Notepad and save with Date/Time in filename 1

Top