chadlaw32
Board Regular
- Joined
- Jul 29, 2014
- Messages
- 84
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
So what i need to do is figure the time between UNPAUSE and PAUSE when the Que and The agent names are the same any ideas? If i put them in order by Agent name, Queue, then stamp I can use this formula to find the time =(B3-B2)/60. It would just save me a load of time if I didn't have to sort the list every day.
A B C D E F
<colgroup><col style="mso-width-source:userset;mso-width-alt:4644;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> </colgroup><tbody>
</tbody>
A B C D E F
time | stamp | callid | queue | agent | action |
10/03/2019 06:02:00 | 1570100520 | NONE | inet-comm | John Doe | UNPAUSE |
10/03/2019 06:02:02 | 1570100522 | NONE | eagle-inet | John Doe | UNPAUSE |
10/03/2019 07:16:58 | 1570105018 | NONE | inet-comm | John Doe | PAUSE |
10/03/2019 07:16:58 | 1570105018 | NONE | inet-comm | John Doe | UNPAUSE |
10/03/2019 07:59:18 | 1570107558 | NONE | eagle-inet | John Smith(W) | UNPAUSE |
10/03/2019 07:59:21 | 1570107561 | NONE | eagle-inet | John Doe | PAUSE |
10/03/2019 08:00:06 | 1570107606 | NONE | inet-comm | John Doe | PAUSE |
10/03/2019 08:00:09 | 1570107609 | NONE | inet-comm | Jane Doe(W) | UNPAUSE |
10/03/2019 08:00:39 | 1570107639 | NONE | eagle-inet | Chuck Farley(W) | UNPAUSE |
10/03/2019 08:01:45 | 1570107705 | NONE | eagle-inet | Michael Hunt(W) | UNPAUSE |
10/03/2019 08:59:24 | 1570111164 | NONE | eagle-inet | Sam Watermeier(W) | UNPAUSE |
10/03/2019 09:08:19 | 1570111699 | NONE | inet-comm | Ted Bundy(W) | UNPAUSE |
10/03/2019 12:00:14 | 1570122014 | NONE | inet-comm | Jane Doe(W) | PAUSE |
10/03/2019 12:02:45 | 1570122165 | NONE | eagle-inet | Chuck Farley(W) | PAUSE |
10/03/2019 12:34:11 | 1570124051 | NONE | eagle-inet | John Smith(W) | PAUSE |
10/03/2019 13:00:48 | 1570125648 | NONE | eagle-inet | Michael Kennedy(H) | UNPAUSE |
10/03/2019 13:00:50 | 1570125650 | NONE | inet-comm | Jane Doe(W) | UNPAUSE |
10/03/2019 13:01:06 | 1570125666 | NONE | eagle-inet | Sam Watermeier(W) | PAUSE |
10/03/2019 13:04:23 | 1570125863 | NONE | eagle-inet | Chuck Farley(W) | UNPAUSE |
10/03/2019 13:09:50 | 1570126190 | NONE | eagle-inet | Michael Hunt(W) | PAUSE |
10/03/2019 13:16:32 | 1570126592 | NONE | inet-comm | Ted Bundy(W) | PAUSE |
10/03/2019 13:31:16 | 1570127476 | NONE | eagle-inet | John Smith(W) | UNPAUSE |
10/03/2019 14:01:20 | 1570129280 | NONE | inet-comm | Ted Bundy(W) | UNPAUSE |
10/03/2019 14:15:48 | 1570130148 | NONE | eagle-inet | Michael Hunt(W) | UNPAUSE |
10/03/2019 16:00:25 | 1570136425 | NONE | eagle-inet | Michael Kennedy(H) | PAUSE |
10/03/2019 16:24:06 | 1570137846 | NONE | eagle-inet | Chris Mann(W) | UNPAUSE |
10/03/2019 16:40:33 | 1570138833 | NONE | eagle-inet | Chris Mann(W) | PAUSE |
10/03/2019 16:59:39 | 1570139979 | NONE | eagle-inet | Chuck Farley(W) | PAUSE |
10/03/2019 17:00:06 | 1570140006 | NONE | inet-comm | Jane Doe(W) | PAUSE |
10/03/2019 17:00:47 | 1570140047 | NONE | eagle-inet | Michael Kennedy(H) | UNPAUSE |
10/03/2019 17:00:52 | 1570140052 | NONE | eagle-inet | John Smith(W) | PAUSE |
10/03/2019 17:02:01 | 1570140121 | NONE | eagle-inet | Sam Watermeier(H) | UNPAUSE |
10/03/2019 17:05:03 | 1570140303 | NONE | eagle-inet | Michael Hunt(W) | PAUSE |
10/03/2019 18:00:18 | 1570143618 | NONE | inet-comm | Ted Bundy(W) | PAUSE |
10/03/2019 18:02:07 | 1570143727 | NONE | inet-comm | Sam Watermeier(H) | UNPAUSE |
10/03/2019 18:02:10 | 1570143730 | NONE | inet-comm | Michael Kennedy(H) | UNPAUSE |
10/03/2019 21:01:01 | 1570154461 | NONE | eagle-inet | Sam Watermeier(H) | PAUSE |
10/03/2019 21:01:03 | 1570154463 | NONE | inet-comm | Sam Watermeier(H) | PAUSE |
10/03/2019 22:08:13 | 1570158493 | NONE | eagle-inet | Michael Kennedy(H) | PAUSE |
10/03/2019 22:08:17 | 1570158497 | NONE | inet-comm | Michael Kennedy(H) | PAUSE |
<colgroup><col style="mso-width-source:userset;mso-width-alt:4644;width:95pt" width="127"> <col style="mso-width-source:userset;mso-width-alt:2816;width:58pt" width="77"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> <col style="mso-width-source:userset;mso-width-alt:2486;width:51pt" width="68"> <col style="mso-width-source:userset;mso-width-alt:4608;width:95pt" width="126"> <col style="mso-width-source:userset;mso-width-alt:2560;width:53pt" width="70"> </colgroup><tbody>
</tbody>
Last edited: