Formatting Time

[Judy]

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

Thanks!

Judy

 

[Randy Harris]

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

 

[Steve Huff]

Here is one way to do it for display purposes:

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

--Steve Huff