chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
75
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

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

mole999

Well-known Member
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
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
 

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
75
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
I cannot use macros due to restrictions in place is there not a formula that would work?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,444
Office Version
  1. 365
Platform
  1. Windows
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,"")
 

chadlaw32

Board Regular
Joined
Jul 29, 2014
Messages
75
Office Version
  1. 365
  2. 2019
  3. 2016
Platform
  1. Windows
That worked great thank you so much!!!!
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
62,444
Office Version
  1. 365
Platform
  1. Windows
My pleasure & thanks for the feedback
 

Forum statistics

Threads
1,141,406
Messages
5,706,268
Members
421,437
Latest member
GijoeBlack

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
Top