I have a spreadsheet that tracks authorization requests.
Column A - time request recieved
Column B - time stamp of when request was pended
Column C - time request was completed.
I am trying to find how to calculate whether we are in compliance.
There are several scenarios:
- Requests should have a turn around time of less than 24 hours business hours
- However, if a request is pended the time between Column A and C can be up to 5 calendar days
Therefore, I'd like to see
1. For all requests that were not pended...were they resolved within 24 business hours (minus holidays, minus non-business hours, we work 8:30am to 5:30pm).
2. For all requests that were pended is the time between Column A and C less than or equal to 5 calendar days...
Any thoughts on how I can do this?
Bookmarks