Military time formats

[Ted]

Can anyone adise on how to format military time please with either AM or PM.

Thanks.

 

[Douglas J. Steele]

Could you give an example of exactly what you're looking for? Your military
time format and mine might not be the same thing....

 

[Douglas J. Steele]

Unfortunately, whenever you ask Access to use the AM/PM designation in the
format, it automatically reverts to the 12 hour clock. What you'll need to
do is use the Format function twice on your time:

Format(MyTime, "hh:nn:ss") & Format(MyTime, " am/pm")

(and that just goes to prove that your version of military time is
completely different than mine: the am/pm is unnecessary when using the 24
hour clock!)

 

[Paul Overway]

Military time format does not include AM/PM. It is implied in the 24 hour
time format....AM/PM would be redundant. 24 hour time format would be:

Format(SomeTime,"hh:nn:ss")

or

Format(SomeTime,"Short Time")

 

[Arvin Meyer]

Military Time does not include the AM/PM designation.

No matter how you enter the data the format property will display it thusly:

Military Time format:

hh:nn:ss

Example: 13:02:18

Civilian Time format:

h:nn:ss AM/PM

Example: 1:02:18 PM

In both cases, you can leave off the last colon and the seconds (ss). On the
Civilian format, you can add the leading zero, and/or use lower case. (hh:nn
am/pm)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Ted]

I would like to display the current system time in military format:


Reg. Time
1:02:18 pm

Militray display
13:02:18 pm