Solved

Military time

Posted on 2002-03-19
4
1,082 Views
Last Modified: 2007-11-27
How do I convert the times in my tables to military time?
0
Comment
Question by:doe5
4 Comments
 
LVL 6

Accepted Solution

by:
Mach1pro earned 100 total points
ID: 6879752
Just change the Format property to 'Short Time'
0
 
LVL 9

Expert Comment

by:Volibrawl
ID: 6879827

I'm prety sure the Hour(sometime) and Minute(sometime)
functions return their answers in Military time as well.  You may find those useful in some circumstances.
0
 
LVL 7

Expert Comment

by:Nosterdamus
ID: 6879864
Hi doe5,

You can also use:
=format(MyTime,"hh:MM")

or what ever format that suits your needs.

HTH,

Nosterdamus
0
 

Author Comment

by:doe5
ID: 6899044
Thanks. Sorry it took so long to respond to your answer.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question