T
Ted
Can anyone adise on how to format military time please with either AM or PM.
Thanks.
Thanks.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
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....
time format and mine might not be the same thing....
D
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!)
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!)
P
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")
time format....AM/PM would be redundant. 24 hour time format would be:
Format(SomeTime,"hh:nn:ss")
or
Format(SomeTime,"Short Time")
A
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
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
T
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
Reg. Time
1:02:18 pm
Militray display
13:02:18 pm