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>
[TD="width: 127"]time
[/TD]
[TD="width: 77"]stamp
[/TD]
[TD="width: 44"]callid
[/TD]
[TD="width: 68"]queue[/TD]
[TD="width: 126"]agent[/TD]
[TD="width: 70"]action[/TD]
[TD="class: xl63, align: right"]10/03/2019 06:02:00[/TD]
[TD="align: right"]1570100520[/TD]
[TD="class: xl63, align: right"]10/03/2019 06:02:02[/TD]
[TD="align: right"]1570100522[/TD]
[TD="class: xl63, align: right"]10/03/2019 07:16:58[/TD]
[TD="align: right"]1570105018[/TD]
[TD="class: xl63, align: right"]10/03/2019 07:16:58[/TD]
[TD="align: right"]1570105018[/TD]
[TD="class: xl63, align: right"]10/03/2019 07:59:18[/TD]
[TD="align: right"]1570107558[/TD]
[TD="class: xl63, align: right"]10/03/2019 07:59:21[/TD]
[TD="align: right"]1570107561[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:00:06[/TD]
[TD="align: right"]1570107606[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:00:09[/TD]
[TD="align: right"]1570107609[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:00:39[/TD]
[TD="align: right"]1570107639[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:01:45[/TD]
[TD="align: right"]1570107705[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:59:24[/TD]
[TD="align: right"]1570111164[/TD]
[TD="class: xl63, align: right"]10/03/2019 09:08:19[/TD]
[TD="align: right"]1570111699[/TD]
[TD="class: xl63, align: right"]10/03/2019 12:00:14[/TD]
[TD="align: right"]1570122014[/TD]
[TD="class: xl63, align: right"]10/03/2019 12:02:45[/TD]
[TD="align: right"]1570122165[/TD]
[TD="class: xl63, align: right"]10/03/2019 12:34:11[/TD]
[TD="align: right"]1570124051[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:00:48[/TD]
[TD="align: right"]1570125648[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:00:50[/TD]
[TD="align: right"]1570125650[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:01:06[/TD]
[TD="align: right"]1570125666[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:04:23[/TD]
[TD="align: right"]1570125863[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:09:50[/TD]
[TD="align: right"]1570126190[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:16:32[/TD]
[TD="align: right"]1570126592[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:31:16[/TD]
[TD="align: right"]1570127476[/TD]
[TD="class: xl63, align: right"]10/03/2019 14:01:20[/TD]
[TD="align: right"]1570129280[/TD]
[TD="class: xl63, align: right"]10/03/2019 14:15:48[/TD]
[TD="align: right"]1570130148[/TD]
[TD="class: xl63, align: right"]10/03/2019 16:00:25[/TD]
[TD="align: right"]1570136425[/TD]
[TD="class: xl63, align: right"]10/03/2019 16:24:06[/TD]
[TD="align: right"]1570137846[/TD]
[TD="class: xl63, align: right"]10/03/2019 16:40:33[/TD]
[TD="align: right"]1570138833[/TD]
[TD="class: xl63, align: right"]10/03/2019 16:59:39[/TD]
[TD="align: right"]1570139979[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:00:06[/TD]
[TD="align: right"]1570140006[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:00:47[/TD]
[TD="align: right"]1570140047[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:00:52[/TD]
[TD="align: right"]1570140052[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:02:01[/TD]
[TD="align: right"]1570140121[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:05:03[/TD]
[TD="align: right"]1570140303[/TD]
[TD="class: xl63, align: right"]10/03/2019 18:00:18[/TD]
[TD="align: right"]1570143618[/TD]
[TD="class: xl63, align: right"]10/03/2019 18:02:07[/TD]
[TD="align: right"]1570143727[/TD]
[TD="class: xl63, align: right"]10/03/2019 18:02:10[/TD]
[TD="align: right"]1570143730[/TD]
[TD="class: xl63, align: right"]10/03/2019 21:01:01[/TD]
[TD="align: right"]1570154461[/TD]
[TD="class: xl63, align: right"]10/03/2019 21:01:03[/TD]
[TD="align: right"]1570154463[/TD]
[TD="class: xl63, align: right"]10/03/2019 22:08:13[/TD]
[TD="align: right"]1570158493[/TD]
[TD="class: xl63, align: right"]10/03/2019 22:08:17[/TD]
[TD="align: right"]1570158497[/TD]
</tbody>
A B C D E F
NONE | inet-comm | John Doe | UNPAUSE |
NONE | eagle-inet | John Doe | UNPAUSE |
NONE | inet-comm | John Doe | PAUSE |
NONE | inet-comm | John Doe | UNPAUSE |
NONE | eagle-inet | John Smith(W) | UNPAUSE |
NONE | eagle-inet | John Doe | PAUSE |
NONE | inet-comm | John Doe | PAUSE |
NONE | inet-comm | Jane Doe(W) | UNPAUSE |
NONE | eagle-inet | Chuck Farley(W) | UNPAUSE |
NONE | eagle-inet | Michael Hunt(W) | UNPAUSE |
NONE | eagle-inet | Sam Watermeier(W) | UNPAUSE |
NONE | inet-comm | Ted Bundy(W) | UNPAUSE |
NONE | inet-comm | Jane Doe(W) | PAUSE |
NONE | eagle-inet | Chuck Farley(W) | PAUSE |
NONE | eagle-inet | John Smith(W) | PAUSE |
NONE | eagle-inet | Michael Kennedy(H) | UNPAUSE |
NONE | inet-comm | Jane Doe(W) | UNPAUSE |
NONE | eagle-inet | Sam Watermeier(W) | PAUSE |
NONE | eagle-inet | Chuck Farley(W) | UNPAUSE |
NONE | eagle-inet | Michael Hunt(W) | PAUSE |
NONE | inet-comm | Ted Bundy(W) | PAUSE |
NONE | eagle-inet | John Smith(W) | UNPAUSE |
NONE | inet-comm | Ted Bundy(W) | UNPAUSE |
NONE | eagle-inet | Michael Hunt(W) | UNPAUSE |
NONE | eagle-inet | Michael Kennedy(H) | PAUSE |
NONE | eagle-inet | Chris Mann(W) | UNPAUSE |
NONE | eagle-inet | Chris Mann(W) | PAUSE |
NONE | eagle-inet | Chuck Farley(W) | PAUSE |
NONE | inet-comm | Jane Doe(W) | PAUSE |
NONE | eagle-inet | Michael Kennedy(H) | UNPAUSE |
NONE | eagle-inet | John Smith(W) | PAUSE |
NONE | eagle-inet | Sam Watermeier(H) | UNPAUSE |
NONE | eagle-inet | Michael Hunt(W) | PAUSE |
NONE | inet-comm | Ted Bundy(W) | PAUSE |
NONE | inet-comm | Sam Watermeier(H) | UNPAUSE |
NONE | inet-comm | Michael Kennedy(H) | UNPAUSE |
NONE | eagle-inet | Sam Watermeier(H) | PAUSE |
NONE | inet-comm | Sam Watermeier(H) | PAUSE |
NONE | eagle-inet | Michael Kennedy(H) | PAUSE |
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>
[TD="width: 127"]time
[/TD]
[TD="width: 77"]stamp
[/TD]
[TD="width: 44"]callid
[/TD]
[TD="width: 68"]queue[/TD]
[TD="width: 126"]agent[/TD]
[TD="width: 70"]action[/TD]
[TD="class: xl63, align: right"]10/03/2019 06:02:00[/TD]
[TD="align: right"]1570100520[/TD]
[TD="class: xl63, align: right"]10/03/2019 06:02:02[/TD]
[TD="align: right"]1570100522[/TD]
[TD="class: xl63, align: right"]10/03/2019 07:16:58[/TD]
[TD="align: right"]1570105018[/TD]
[TD="class: xl63, align: right"]10/03/2019 07:16:58[/TD]
[TD="align: right"]1570105018[/TD]
[TD="class: xl63, align: right"]10/03/2019 07:59:18[/TD]
[TD="align: right"]1570107558[/TD]
[TD="class: xl63, align: right"]10/03/2019 07:59:21[/TD]
[TD="align: right"]1570107561[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:00:06[/TD]
[TD="align: right"]1570107606[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:00:09[/TD]
[TD="align: right"]1570107609[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:00:39[/TD]
[TD="align: right"]1570107639[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:01:45[/TD]
[TD="align: right"]1570107705[/TD]
[TD="class: xl63, align: right"]10/03/2019 08:59:24[/TD]
[TD="align: right"]1570111164[/TD]
[TD="class: xl63, align: right"]10/03/2019 09:08:19[/TD]
[TD="align: right"]1570111699[/TD]
[TD="class: xl63, align: right"]10/03/2019 12:00:14[/TD]
[TD="align: right"]1570122014[/TD]
[TD="class: xl63, align: right"]10/03/2019 12:02:45[/TD]
[TD="align: right"]1570122165[/TD]
[TD="class: xl63, align: right"]10/03/2019 12:34:11[/TD]
[TD="align: right"]1570124051[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:00:48[/TD]
[TD="align: right"]1570125648[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:00:50[/TD]
[TD="align: right"]1570125650[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:01:06[/TD]
[TD="align: right"]1570125666[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:04:23[/TD]
[TD="align: right"]1570125863[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:09:50[/TD]
[TD="align: right"]1570126190[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:16:32[/TD]
[TD="align: right"]1570126592[/TD]
[TD="class: xl63, align: right"]10/03/2019 13:31:16[/TD]
[TD="align: right"]1570127476[/TD]
[TD="class: xl63, align: right"]10/03/2019 14:01:20[/TD]
[TD="align: right"]1570129280[/TD]
[TD="class: xl63, align: right"]10/03/2019 14:15:48[/TD]
[TD="align: right"]1570130148[/TD]
[TD="class: xl63, align: right"]10/03/2019 16:00:25[/TD]
[TD="align: right"]1570136425[/TD]
[TD="class: xl63, align: right"]10/03/2019 16:24:06[/TD]
[TD="align: right"]1570137846[/TD]
[TD="class: xl63, align: right"]10/03/2019 16:40:33[/TD]
[TD="align: right"]1570138833[/TD]
[TD="class: xl63, align: right"]10/03/2019 16:59:39[/TD]
[TD="align: right"]1570139979[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:00:06[/TD]
[TD="align: right"]1570140006[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:00:47[/TD]
[TD="align: right"]1570140047[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:00:52[/TD]
[TD="align: right"]1570140052[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:02:01[/TD]
[TD="align: right"]1570140121[/TD]
[TD="class: xl63, align: right"]10/03/2019 17:05:03[/TD]
[TD="align: right"]1570140303[/TD]
[TD="class: xl63, align: right"]10/03/2019 18:00:18[/TD]
[TD="align: right"]1570143618[/TD]
[TD="class: xl63, align: right"]10/03/2019 18:02:07[/TD]
[TD="align: right"]1570143727[/TD]
[TD="class: xl63, align: right"]10/03/2019 18:02:10[/TD]
[TD="align: right"]1570143730[/TD]
[TD="class: xl63, align: right"]10/03/2019 21:01:01[/TD]
[TD="align: right"]1570154461[/TD]
[TD="class: xl63, align: right"]10/03/2019 21:01:03[/TD]
[TD="align: right"]1570154463[/TD]
[TD="class: xl63, align: right"]10/03/2019 22:08:13[/TD]
[TD="align: right"]1570158493[/TD]
[TD="class: xl63, align: right"]10/03/2019 22:08:17[/TD]
[TD="align: right"]1570158497[/TD]
</tbody>
Last edited: