Work Hours w/o Weekend

  • Thread starter Thread starter ty
  • Start date Start date
T

ty

Is there a way to count the number of hours (or days)
between two dates in a table, but excluding the weekend
hours (or days) when applicable?

I've seen some previous postings, but I can't even begin
to understand them. Please help in the easiest possible
way.
 
Yes, there are ways to count work days and the best collection of functions
to get this job done (in my opinion) is found at the Access Web:

Doing Workday Math in VBA:
http://www.mvps.org/access/datetime/date0012.htm

There is a lot of code here, but as you work through it, you will see that
all of the functions are quite necessary to get the job done. You will also
see that each function is heavily commented to show you how it works and how
it is called.
 
Back
Top