time formats

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I format time to hh:mm am/pm (hours and minutes with am or pm in
lowercase)?
 
The statement
Format(Time(),"hh:nn am/pm")
does what you are asking. Minutes are "n", "m" is Months.

Placing
hh:nn am/pm
in the Format property of a textbox will do the same thing.
 
How do I format time to hh:mm am/pm (hours and minutes with am or pm in
lowercase)?

m means Months, n means miNutes...

Try

hh:nn a/p

John W. Vinson[MVP]
 

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

Back
Top