Datediff

[Alan Zanini]

Hi, I Have to calculate the difference in hours between dates and times
ignoring weekends, holidays and the hours between 6 Pm till 9 Am.
Do any one know how could I do that

 

[Daniel Pineault]

The following links will provide you with workday functions

http://www.mvps.org/access/datetime/date0006.htm
http://www.mvps.org/access/datetime/date0012.htm

These will permit you to determine the number of business days between you 2
dates. From there you need only multiply by 8 hours (business hours or 24
hour for a full day - depends on your needs) and add that to the difference
between the start and end time of the first and last day. May take a little
fiddling but everything you need should be here.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.com/index.php
Please rate this post using the vote buttons if it was helpful.

 

[Alan Zanini]

Thanks but I think placed my question in the wrong place, I don't realy know
how to use this codes.
Thanks any way.