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

timecard

lee123
100+
P: 556
i have made a form to keep track of hours worked:

my question is how do you get it to add up the hours in a query

Example:

time in: 6:00 am
time out: 2:30 pm

would = 8.5 hrs

lee123
Dec 8 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
i have made a form to keep track of hours worked:

my question is how do you get it to add up the hours in a query

Example:

time in: 6:00 am
time out: 2:30 pm

would = 8.5 hrs

lee123
Lee,
At this link, page down to the section on computing elapsed time, and the section on employing elapsed time in queries, forms, and reports. The link provides source code for a function that can be called from your subs and queries to do the computations as needed.

http://office.microsoft.com/en-us/ac...102181033.aspx
Dec 8 '07 #2

Post your reply

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