By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,253 Members | 1,693 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,253 IT Pros & Developers. It's quick & easy.

Formatting Time

P: n/a
How do I format the times 10:30 AM to get 10:30A and 12:30 PM to get 12:30P?

Thanks!

Judy
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Judy" <jr*******@notmyemail.com> wrote in message
news:CX***************@newsread3.news.atl.earthlin k.net...
How do I format the times 10:30 AM to get 10:30A and 12:30 PM to get 12:30P?
Thanks!

Judy


This is right out of the Access Help:

Debug.Print Format(Time, "h:mmA/P")

HTH,
Randy
Nov 13 '05 #2

P: n/a
Here is one way to do it for display purposes:

=left(format(now(),"hh:mm ampm"),7)

--Steve Huff

"Judy" <jr*******@notmyemail.com> wrote in message
news:CX***************@newsread3.news.atl.earthlin k.net...
How do I format the times 10:30 AM to get 10:30A and 12:30 PM to get
12:30P?

Thanks!

Judy

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.