Military Time Conversion

[Guest]

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

 

[MGFoster]

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

In what context?

Format(time_expression, "HH:MM AMPM")

 

[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

 

[JohnFol]

If you mean 24 hour clock, then use this

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