General discussion
January 5, 2005 at 04:12 PM
rhowens

Date query based on business hours

by rhowens . Updated 21 years, 9 months ago

I need to create an Access query that pulls data based on an open_date and closed_date. I compute the time it takes to close a ticket on these two fields with the datediff command. The problem is the users do not work 24/7 and the time that the users are not working should not be considered. I need to calculate the hours it takes to close a ticket but not consider non-working hours. Any ideas?

Thanks!

This discussion is locked

All Comments