Create a table with 48 rows of data ( one row for each half-hour in 24 hours )

In column A enter the estimated number of call received in that half-hour slot
In column B enter the estimated time to process a call (should include any
record-keeping overhead)

In column C enter:
=A1*B1/30

This is the minimum staffing. Include margin for people go on break, lunch,
etc.
--
Gary's Student


"Denniso6" wrote:

I'm attempting to build a spreadsheet that calculates call-center staffing
requirements by half hour. Any recommendations as to how I get started would
be appricated.