Per hour?

Shamas

Board Regular
Joined
Aug 24, 2006
Messages
64
P1 = 317.75 hours (0.25 is equivalent to 15mins)
P2 = 3994 contacts (number of calls made)
P3 = 15 Agents

15 agents over a total of 317.75 hours made 3994 customer contacts. What formula would I use in cell P5 to work out the number of contacts per hour?

I can’t use the html maker on my work pc unfortunately to post a screen shot

All help much appreciated ;)
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
46,248
Office Version
  1. 365
Platform
  1. Windows
.. or if you want 'Contacts per agent per hour' use:
=P2/P3/P1
 

Shamas

Board Regular
Joined
Aug 24, 2006
Messages
64
Thanks people, slightly embarraing because that now seems so basic. Thanks again
 

Watch MrExcel Video

Forum statistics

Threads
1,109,040
Messages
5,526,412
Members
409,701
Latest member
nitmani

This Week's Hot Topics

Top