Military Time Conversion

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

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
 
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")
 
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
 
If you mean 24 hour clock, then use this

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