chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
84
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. 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
time
stamp
callid
queueagentaction
10/03/2019 06:02:001570100520NONEinet-commJohn DoeUNPAUSE
10/03/2019 06:02:021570100522NONEeagle-inetJohn DoeUNPAUSE
10/03/2019 07:16:581570105018NONEinet-commJohn DoePAUSE
10/03/2019 07:16:581570105018NONEinet-commJohn DoeUNPAUSE
10/03/2019 07:59:181570107558NONEeagle-inetJohn Smith(W)UNPAUSE
10/03/2019 07:59:211570107561NONEeagle-inetJohn DoePAUSE
10/03/2019 08:00:061570107606NONEinet-commJohn DoePAUSE
10/03/2019 08:00:091570107609NONEinet-commJane Doe(W)UNPAUSE
10/03/2019 08:00:391570107639NONEeagle-inetChuck Farley(W)UNPAUSE
10/03/2019 08:01:451570107705NONEeagle-inetMichael Hunt(W)UNPAUSE
10/03/2019 08:59:241570111164NONEeagle-inetSam Watermeier(W)UNPAUSE
10/03/2019 09:08:191570111699NONEinet-commTed Bundy(W)UNPAUSE
10/03/2019 12:00:141570122014NONEinet-commJane Doe(W)PAUSE
10/03/2019 12:02:451570122165NONEeagle-inetChuck Farley(W)PAUSE
10/03/2019 12:34:111570124051NONEeagle-inetJohn Smith(W)PAUSE
10/03/2019 13:00:481570125648NONEeagle-inetMichael Kennedy(H)UNPAUSE
10/03/2019 13:00:501570125650NONEinet-commJane Doe(W)UNPAUSE
10/03/2019 13:01:061570125666NONEeagle-inetSam Watermeier(W)PAUSE
10/03/2019 13:04:231570125863NONEeagle-inetChuck Farley(W)UNPAUSE
10/03/2019 13:09:501570126190NONEeagle-inetMichael Hunt(W)PAUSE
10/03/2019 13:16:321570126592NONEinet-commTed Bundy(W)PAUSE
10/03/2019 13:31:161570127476NONEeagle-inetJohn Smith(W)UNPAUSE
10/03/2019 14:01:201570129280NONEinet-commTed Bundy(W)UNPAUSE
10/03/2019 14:15:481570130148NONEeagle-inetMichael Hunt(W)UNPAUSE
10/03/2019 16:00:251570136425NONEeagle-inetMichael Kennedy(H)PAUSE
10/03/2019 16:24:061570137846NONEeagle-inetChris Mann(W)UNPAUSE
10/03/2019 16:40:331570138833NONEeagle-inetChris Mann(W)PAUSE
10/03/2019 16:59:391570139979NONEeagle-inetChuck Farley(W)PAUSE
10/03/2019 17:00:061570140006NONEinet-commJane Doe(W)PAUSE
10/03/2019 17:00:471570140047NONEeagle-inetMichael Kennedy(H)UNPAUSE
10/03/2019 17:00:521570140052NONEeagle-inetJohn Smith(W)PAUSE
10/03/2019 17:02:011570140121NONEeagle-inetSam Watermeier(H)UNPAUSE
10/03/2019 17:05:031570140303NONEeagle-inetMichael Hunt(W)PAUSE
10/03/2019 18:00:181570143618NONEinet-commTed Bundy(W)PAUSE
10/03/2019 18:02:071570143727NONEinet-commSam Watermeier(H)UNPAUSE
10/03/2019 18:02:101570143730NONEinet-commMichael Kennedy(H)UNPAUSE
10/03/2019 21:01:011570154461NONEeagle-inetSam Watermeier(H)PAUSE
10/03/2019 21:01:031570154463NONEinet-commSam Watermeier(H)PAUSE
10/03/2019 22:08:131570158493NONEeagle-inetMichael Kennedy(H)PAUSE
10/03/2019 22:08:171570158497NONEinet-commMichael 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:

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.
you can create a macro book that is available when you load excel, so it should be possible to import the data once, trigger the macro to do the job you want and proceed
 
Upvote 0
I cannot use macros due to restrictions in place is there not a formula that would work?
 
Upvote 0
How about in G2 copied down
=IF(F2="unpause",INDEX($A2:$A$41,MATCH(D2&"|"&E2&"|pause",INDEX($D2:$D$41&"|"&$E2:$E$241&"|"&$F2:$F$241,0),0))-A2,"")
 
Upvote 0
My pleasure & thanks for the feedback
 
Upvote 0

Forum statistics

Threads
1,213,497
Messages
6,113,999
Members
448,543
Latest member
MartinLarkin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top