Returning Times for Jobs based only on working days

[Workaholic]

I have designed a query that shows the time taken for an IT job, from when it was opened to when it was completed. The problem is I need the time factor to be a criteria based on working hours, ie Mon-Frid, 8.00 - 18.00.

How can you base a time criteria within these constraints?

 

[Kraj]

Useful Date Functions

I don't think you'll find exactly what you're looking for in there, but it might at least help you search or try different methods. I'm not familiar enough with date/time functions to give you a direct answer. Sorry