By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,471 Members | 2,264 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,471 IT Pros & Developers. It's quick & easy.

Time conversion from military to clock time

P: 1
I have two fields Time-in & Time-out that are in military time. I have to calculate the difference (to get the total amt. of time spent working) then show the time as clock time. I've only been working with Access for 2 weeks and am not at the level yet to do this.
Oct 14 '07 #1
Share this Question
Share on Google+
2 Replies


FishVal
Expert 2.5K+
P: 2,653
Hi, Renee.

Try something like this.

Expand|Select|Wrap|Line Numbers
  1. Format([Time-out]-[Time-in],"hh:mm")
  2.  
Oct 14 '07 #2

NeoPa
Expert Mod 15k+
P: 31,186
I have two fields Time-in & Time-out that are in military time. I have to calculate the difference (to get the total amt. of time spent working) then show the time as clock time. I've only been working with Access for 2 weeks and am not at the level yet to do this.
Are the military time fields stored as strings? Or are they Date/Time fields merely displayed in that format?
Oct 14 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.