Datediff

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Alan Zanini - 22 May 2008 12:06 GMT

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

Reply to this Message

Daniel Pineault - 22 May 2008 13:05 GMT

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.

Signature

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.

> 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

Reply to this Message

Alan Zanini - 23 May 2008 12:23 GMT

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

> The following links will provide you with workday functions
>
[quoted text clipped - 10 lines]
> > ignoring weekends, holidays and the hours between 6 Pm till 9 Am.
> > Do any one know how could I do that

Reply to this Message