Trebor8484
Board Regular
- Joined
- Oct 27, 2018
- Messages
- 69
- Office Version
- 2013
- Platform
- Windows
Hi, I am trying to find a way to track how quickly we respond to our engineer queries in working days (Monday - Friday).
When a query comes in it goes into an Open status. When it is responded to it goes into another status which could be a number of different statuses, i.e. Pended/Closed etc.
So in my example it would need to display 1 working day to respond the first engineer and 2 days for the second. The formula would only need to apply for rows showing as Open status as that would always relate to a new query.
Thanks
When a query comes in it goes into an Open status. When it is responded to it goes into another status which could be a number of different statuses, i.e. Pended/Closed etc.
So in my example it would need to display 1 working day to respond the first engineer and 2 days for the second. The formula would only need to apply for rows showing as Open status as that would always relate to a new query.
Thanks