J
James
I work for a call center and I want to be able to determine the first and
second instance of a person's break.
My current euqation for lunches is
=SUMPRODUCT(--((Data!$D$2:$D$65500)=$A3),--((Data!$E$2:$E$65500)=$B$3),--((Data!$G$2:$G$65500)=3),(Data!$H$2:$H$65500))
Where A3=agent, Col D agent lookup column, B3=date, Col E=dates, 3 represent
the lunch state found in Col G, and the time taken is in col H.
How do I re-write this part "--((Data!$G$2:$G$65500)=3)" for breaks (=7)
when there are two of them?
I will also run into issues if they split their time. I have 250 agents and
I'd like to build this for a week or two, so manual entry sounds is less than
exciting, especially when the data is 25,000 lines.
second instance of a person's break.
My current euqation for lunches is
=SUMPRODUCT(--((Data!$D$2:$D$65500)=$A3),--((Data!$E$2:$E$65500)=$B$3),--((Data!$G$2:$G$65500)=3),(Data!$H$2:$H$65500))
Where A3=agent, Col D agent lookup column, B3=date, Col E=dates, 3 represent
the lunch state found in Col G, and the time taken is in col H.
How do I re-write this part "--((Data!$G$2:$G$65500)=3)" for breaks (=7)
when there are two of them?
I will also run into issues if they split their time. I have 250 agents and
I'd like to build this for a week or two, so manual entry sounds is less than
exciting, especially when the data is 25,000 lines.