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

Elapsed Time in workdays (M-F, 8-5)?

P: n/a


I really need to compute elapsed time using Access and VBA. I have two
date/time Access table fields, one for Start and one for Finish. I am
trying to calculate net workday work hours. If a trouble ticket is not
resolved (Finish) on the same day, I need to calculate how many 8a-5p
Mon-Fri workday hours elapsed. HELP, please!

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Breaking it down,
1. return the number of whole workdays between the start and finish
dates.
2. multiply that by the length of the workday.
3. get the difference in hours between the start and the end of the
end of the workday.
4. get the difference in hours between the finish and the start of
that workday.
5. Add result from #2 to #3 to #4 and there you go.

Getting the number of workdays between the two dates:
http://www.datastrat.com/Code/GetBusinessDay.txt

HTH,
Pieter
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.