Solved

Military time

Posted on 2002-03-19
4
1,062 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

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

747 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now