Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How would you do miltary time in VB in access

Status
Not open for further replies.
zrazzaq

zrazzaq

MIS
Apr 13, 2005
102
US
Hi all:
I have to sum a bunch of rows which are Time fields in it. The end result needs to be in military time. Anyone got anything for this.
 
Sort by date Sort by votes
Set the format of your DateTime field to Short Time. This will put the values into military time format.
 
Upvote 0 Downvote
Actually I figured that out in a query. The only thing left is I have something like 17:34 which is 17 minutes and 34 seconds. The issue is that it keeps coming up with AM at the end of it. I try to format it and it did not work...Anyone got any suggestions for it.
Thanks
Zishan
 
Upvote 0 Downvote
The input mask for Medium Time is 99:00 >LL. Try removing the >LL.


Randy
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

M
  • Locked
  • Question
display a calendar with appointments in body of html email with access vba
Replies
1
Views
3K
SoftwareRT
SoftwareRT
DarkOne72
  • Locked
  • Question
MS Access DoCmd.Transferdatabase Assistance
Replies
2
Views
2K
lameid
lameid
BFroeschlKC
  • Locked
  • Question
Publisher Automation from Access Frustration
Replies
3
Views
2K
dhookom
dhookom
Moss100
  • Locked
  • Question
Access send email attachments - problem when null or empty
Replies
7
Views
2K
Andrzejek
Andrzejek
Aurillius
  • Locked
  • Question
Convert Date/Time cell to a date and time in VBA
Replies
2
Views
774
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top