K
kr
i have a table of information. as follows
Call Time Call Frm Call To Talk Time
12:01 Joe Me 0
12:06 Jed Me 56
3:05 Anna You 12
5:55 Ted Them 25
10:11 Joe Us 55
From there, I'm making the following columns.
Total Calls by hour: I use the sumproduct for this
Total Unique Calls: The excel forum guys helped me with this
But, what if I want to say, give me the unique times for call from by hour
that does not have a "0" talk time. What i want to say in expression is
"count only the first time the record shows up in the report and include in
the time"
Make sense?
Call Time Call Frm Call To Talk Time
12:01 Joe Me 0
12:06 Jed Me 56
3:05 Anna You 12
5:55 Ted Them 25
10:11 Joe Us 55
From there, I'm making the following columns.
Total Calls by hour: I use the sumproduct for this
Total Unique Calls: The excel forum guys helped me with this
But, what if I want to say, give me the unique times for call from by hour
that does not have a "0" talk time. What i want to say in expression is
"count only the first time the record shows up in the report and include in
the time"
Make sense?