I need to add a calculated control to my report with calculates the difference in hours between two dates. However, the problem I'm having is that the calculation must exclude Saturdays and Sundays.
We need to track the # hours it takes to complete work in our department. I have two Date/Time fields; one to record both date and time work was Logged In and one to record date and time Logged Out. We need to know if we are reaching our goal of completing work in a 24 hour period. But obviously, we don't want to include weekends in the calculation.
I've searched and searched and can't find an answer....please help.
FranD
We need to track the # hours it takes to complete work in our department. I have two Date/Time fields; one to record both date and time work was Logged In and one to record date and time Logged Out. We need to know if we are reaching our goal of completing work in a 24 hour period. But obviously, we don't want to include weekends in the calculation.
I've searched and searched and can't find an answer....please help.
FranD
