software

Hello,

I have a couple questions today. And let me thank you in advance for your
help – this is a great forum.

Question 1:
Below is a chart. What I need help with is matching the agent name (column
A) to the Event Type “Logon” (column B) and record the minimum time (from
column D) this event type was used (logon that is). I also need to have the
max time for “logoff”, but I assume I will replace the “Logon” and min in the
formula you provide.

Questions 2:
Matching the agents name (from column A) and matching “ACD Incoming” (from
column B) I need help with a formula that will count the number of times
Q10556, Q10557, Q10558 and Q10559 appear in the queue (column E).

Again I appreciate your time and help.

A B C D
E
Name Event Type Date Time Queue
Agent LOGON 2/20/2006 11:11:18 Q10556
Agent WRAPUP 2/20/2006 11:11:19
Agent LOGON 2/20/2006 11:11:24 Q10557
Agent WRAPUP 2/20/2006 11:11:25
Agent AVAILABLE 2/20/2006 11:11:29
Agent ACD INCOMING 2/20/2006 11:12:51 Q10556
Agent LOGOFF 2/20/2006 15:28:46 Q10556
Agent WRAPUP 2/20/2006 15:28:47
Agent WRAPUP 2/20/2006 15:28:49
Agent LOGOFF 2/20/2006 15:28:49 Q10557
Agent LOGOFF 2/20/2006 17:27:16 Q10556
For the first part:

If your data spans more than 1 day...

=MIN(IF(A2:A12=quot;Agentquot;,IF(B2:B12=quot;Logonquot;,(C2:C12 D 212))))

Otherwise, the following would suffice...

=MIN(IF(A2:A12=quot;Agentquot;,IF(B2:B12=quot;Logonquot;,D212)))

Note that both formulas need to be confirmed with CONTROL SHIFT ENTER,
not just ENTER.

For the second part:

=SUMPRODUCT(--(A2:A12=quot;Agentquot;),--(B2:B12=quot;ACD
Incomingquot;),--(E2:E12=quot;Q10556quot;))

Hope this helps!

In article gt;,
quot;JRquot; gt; wrote:

gt; Hello,
gt;
gt; I have a couple questions today. And let me thank you in advance for your
gt; help – this is a great forum.
gt;
gt; Question 1:
gt; Below is a chart. What I need help with is matching the agent name (column
gt; A) to the Event Type “Logon” (column B) and record the minimum time (from
gt; column D) this event type was used (logon that is). I also need to have the
gt; max time for “logoff”, but I assume I will replace the “Logon” and min in the
gt; formula you provide.
gt;
gt; Questions 2:
gt; Matching the agents name (from column A) and matching “ACD Incoming” (from
gt; column B) I need help with a formula that will count the number of times
gt; Q10556, Q10557, Q10558 and Q10559 appear in the queue (column E).
gt;
gt; Again I appreciate your time and help.
gt;
gt; A B C D
gt; E
gt; Name Event Type Date Time Queue
gt; Agent LOGON 2/20/2006 11:11:18 Q10556
gt; Agent WRAPUP 2/20/2006 11:11:19
gt; Agent LOGON 2/20/2006 11:11:24 Q10557
gt; Agent WRAPUP 2/20/2006 11:11:25
gt; Agent AVAILABLE 2/20/2006 11:11:29
gt; Agent ACD INCOMING 2/20/2006 11:12:51 Q10556
gt; Agent LOGOFF 2/20/2006 15:28:46 Q10556
gt; Agent WRAPUP 2/20/2006 15:28:47
gt; Agent WRAPUP 2/20/2006 15:28:49
gt; Agent LOGOFF 2/20/2006 15:28:49 Q10557
gt; Agent LOGOFF 2/20/2006 17:27:16 Q10556

With regards to the first part, I forgot to mention to format your cells
as 'Time'...

Hope this helps!

In article gt;,
Domenic gt; wrote:

gt; For the first part:
gt;
gt; If your data spans more than 1 day...
gt;
gt; =MIN(IF(A2:A12=quot;Agentquot;,IF(B2:B12=quot;Logonquot;,(C2:C12 D 212))))
gt;
gt; Otherwise, the following would suffice...
gt;
gt; =MIN(IF(A2:A12=quot;Agentquot;,IF(B2:B12=quot;Logonquot;,D212)))
gt;
gt; Note that both formulas need to be confirmed with CONTROL SHIFT ENTER,
gt; not just ENTER.
gt;
gt; For the second part:
gt;
gt; =SUMPRODUCT(--(A2:A12=quot;Agentquot;),--(B2:B12=quot;ACD
gt; Incomingquot;),--(E2:E12=quot;Q10556quot;))
gt;
gt; Hope this helps!