its returning:




0:41:03



Let me know what you need to help me. Also, I just learned this morning
that when I export the ACD data each associate that is listed will have a
header row. Will the multiple header rows make a difference with the formula?

"Domenic" wrote:

Okay, let's look at this step by step...

For the first break we have...

Associate 1BRK 2/8/06 9:27:51
Associate AVAILABLE 2/8/06 9:40:25

....giving us a total of 0:12:34.

For the second break we have...

Associate 1BRK 2/8/06 13:50:28
Associate AVAILABLE 2/8/06 14:06:38

....giving us a total of 0:16:10

Altogether, the total should be 0:28:44, which is what the formula
returns. Is this not correct?

In article ,
"JR" wrote:

Domenic,

Here is the formula I am using:

=SUMPRODUCT(--(B2:B4999=G5),--(C2:C4999="1BRK"),(D3:D5000+E3:E5000)-(D2:D4999+
E2:E4999))

However the formula is returning a value of 41:03, when the return should be
25:02.

Any thoughts?

Here is the data again:

A B C D
Name Event Type Date Start Time
Associate 1 LOGON 2/8/2006 6:58:54
Associate 1 LOGOFF 2/8/2006 6:59:03
Associate 1 LOGON 2/8/2006 6:59:06
Associate 1 LOGON 2/8/2006 6:59:07
Associate 1 LOGON 2/8/2006 6:59:14
Associate 1 8WRP 2/8/2006 8:41:20
Associate 1 AVAILABLE 2/8/2006 8:43:46


Associate 1 1BRK 2/8/2006 9:27:51
Associate 1 AVAILABLE 2/8/2006 9:40:25


Associate 1 8WRP 2/8/2006 10:05:09
Associate 1 AVAILABLE 2/8/2006 10:07:28
Associate 1 8WRP 2/8/2006 10:20:32
Associate 1 AVAILABLE 2/8/200 10:27:58
Associate 1 8WRP 2/8/2006 11:12:14
Associate 1 AVAILABLE 2/8/2006 11:27:46
Associate 1 2LUN 2/8/2006 11:27:48
Associate 1 AVAILABLE 2/8/2006 12:05:32
Associate 1 8WRP 2/8/2006 12:35:06
Associate 1 AVAILABLE 2/8/2006 13:06:47
Associate 1 4CST 2/8/2006 13:06:49
Associate 1 AVAILABLE 2/8/2006 13:09:33
Associate 1 9OTH 2/8/2006 13:29:06
Associate 1 AVAILABLE 2/8/2006 13:50:04


Associate 1 1BRK 2/8/2006 13:50:28
Associate 1 AVAILABLE 2/8/2006 14:06:38


Associate 1 LOGOFF 2/8/2006 15:28:44
Associate 1 UNAVAILABLE 2/8/2006 15:28:50
Associate 1 AVAILABLE 2/8/2006 15:31:50
Associate 1 LOGOFF 2/8/2006 15:31:54



"Domenic" wrote:

Assumptions:

A1:D1 contains the headers/labels

A2:D32 contains the data

F2 contains the 'Associate' of interest

Formula:

=SUMPRODUCT(--(A2:A31=F2),--(B2:B31="1BRK"),(C3:C32+D3:D32)-(C2:C31+D2:D3
1))

Hope this helps!

In article ,
"JR" wrote:

Okay,

You saved my life. Now if your willing to jump back into the river to
find
my wallet. Can you help me out by adding the total time the associate
spend
on break. You will notice on the example I posted there are two breaks
(1BRK). Can you help with a formula that will Talley the total break
time,
which is total between the 1BRK time and the time next to the available
immediately following the 1BRK

A B C D
Name Event Type Date Start Time
Associate 1 LOGON 2/8/2006 6:58:54
Associate 1 LOGOFF 2/8/2006 6:59:03
Associate 1 LOGON 2/8/2006 6:59:06
Associate 1 LOGON 2/8/2006 6:59:07
Associate 1 LOGON 2/8/2006 6:59:14
Associate 1 8WRP 2/8/2006 8:41:20
Associate 1 AVAILABLE 2/8/2006 8:43:46


Associate 1 1BRK 2/8/2006 9:27:51
Associate 1 AVAILABLE 2/8/2006 9:40:25


Associate 1 8WRP 2/8/2006 10:05:09
Associate 1 AVAILABLE 2/8/2006 10:07:28
Associate 1 8WRP 2/8/2006 10:20:32
Associate 1 AVAILABLE 2/8/200 10:27:58
Associate 1 8WRP 2/8/2006 11:12:14
Associate 1 AVAILABLE 2/8/2006 11:27:46
Associate 1 2LUN 2/8/2006 11:27:48
Associate 1 AVAILABLE 2/8/2006 12:05:32
Associate 1 8WRP 2/8/2006 12:35:06
Associate 1 AVAILABLE 2/8/2006 13:06:47
Associate 1 4CST 2/8/2006 13:06:49
Associate 1 AVAILABLE 2/8/2006 13:09:33
Associate 1 9OTH 2/8/2006 13:29:06
Associate 1 AVAILABLE 2/8/2006 13:50:04


Associate 1 1BRK 2/8/2006 13:50:28
Associate 1 AVAILABLE 2/8/2006 14:06:38


Associate 1 LOGOFF 2/8/2006 15:28:44
Associate 1 UNAVAILABLE 2/8/2006 15:28:50
Associate 1 AVAILABLE 2/8/2006 15:31:50
Associate 1 LOGOFF 2/8/2006 15:31:54