Team Schedules. I have 2 tables - 1 with an agents daily schedule and 1 that reports the agents telephone time in a given state (phone, avail, on call, aux). Table 1 (Schedules) is in 15 minute intervals - Table 2 (Agent Time In State) reports their activity for the entire day by time.
I need to track what the agent was doing for each 15 minute interval during the day based on the Agent Time In State table. e.g. If the agent is scheduled to be on the phone from 8:00 - 8:15 and the Agent Time report has them taking calls (ACD) and not taking calls (AUX) - I need the query to return the amount of time that the agent was in each state during the interval. Each interval should add up to 15 minutes.
I can provide a sample to provide more detail.
9 freelancers are bidding on average $26/hour for this job
Hello Sir, I understand your [login to view URL] will use few formula and than it can be [login to view URL] are looking forward for your positive response. Thanks and Regards Karan