473,385 Members | 2,014 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,385 software developers and data experts.

Time conversion from military to clock time

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
2 3117
FishVal
2,653 Expert 2GB
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
32,556 Expert Mod 16PB
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

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

Similar topics

9
by: Fabian | last post by:
I had a very quiet schedule at work today, so I thought I'd finish this script. In theory, it should generate a random time between two moments specified, round it off to a conventional interval if...
21
by: Javier | last post by:
Hi IŽve a routine that will read date and times in a vector of strings ie: 30/02/2005 19:20 In some moment IŽll need to check if there are in vector a date like current date with a time...
9
by: ME | last post by:
can someone tell me how to make this first one work??, located here: http://javascript.about.com/library/scripts/blshowdatetime.htm#examplesource This second one, well, dreamweaver eats the code,...
2
by: Al | last post by:
Hi Is it a function to convert time to and from military time? Thanks
4
by: richardkreidl | last post by:
How would I check to see if the current time(military format) is greater then 07:30AM and the day of the week is Monday-Friday. Pseudo code: If Current_Time > 07:30AM and Current_Day = Monday...
18
by: Giovanni Bajo | last post by:
Hello, I experimented something very strange, a few days ago. I was debugging an application at a customer's site, and the problem turned out to be that time.clock() was going "backwards", that...
8
by: Phillip Vong | last post by:
Simple question from a newbie. Using VWD in VB.NET for ASP.NET. I want to format a time value to show in military time only and without the seconds. I know it's not {0:t} or {0:T} but I can not...
1
by: ken | last post by:
Mostly so I can find this again when I need it: function formatTime(t) { var myTime = t.value; var badFormat = "Bad format"; // Ensure we have a value if (myTime == "") { return(true); }
4
by: drg | last post by:
My assignment is actually encapsulation which is not the problem -- my program needs to take two military times and calculate the minutes elapsed between the two. I have everything worked out so...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.