Military Time Conversion

J

Jeffiner11

This is probably extremely basic, but is there some type of formula that
converts military time into standard AM/PM format?

Thanks for your help!

Jenn
 
M

MGFoster

Jeffiner11 said:
This is probably extremely basic, but is there some type of formula that
converts military time into standard AM/PM format?
Click to expand...

In what context?

Format(time_expression, "HH:MM AMPM")
 
L

LMB

Hi Jenn,

I am a beginner so I hope this is right. I don't know about a in a query but if you have the field on a form or on a report, you can click on the text box that displays your time and go into the properties and then select medium time from the drop down menu. I usually select the time type when I make my table, then if I need it displayed differently in my form or report I use the properties sheet in that object.

Linda
This is probably extremely basic, but is there some type of formula that
converts military time into standard AM/PM format?

Thanks for your help!

Jenn
 
J

JohnFol

If you mean 24 hour clock, then use this

format ( myDateTimeVale , "hh:nn:ss AM/PM")
 
Top