Calculate Time and exclude weekends

[hmirones]

Hello, I'm new to access and I have been working on a query in which I have to Dates one is Open time and the other Closed Time and we want to calculate the time in hours the ticket was took to be completed but we do not want weekends to impact the amount of hours.

Thanks for the help

 

[plog]

At least once a week this is asked. Here's the thread from last week:

https://www.access-programmers.co.uk/forums/showthread.php?t=298427&highlight=exclude+weekends

If that doesn't work, use the search function and you can probably find one that is specfically tailored to your situation.

 

[Ranman256]

in your base query, make a field to show Day Of Week.
Dow: format([workDate],"ddd")

then you can exclude these dates in the 2nd query
select * from qsWork where Dow<>'Sat' and Dow<>'Sun'