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.

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.

I'll try this!

Much appreciated. - D

"Gary''s Student" wrote:

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.

I am thinking about doing the same thing, have you managed to do this? If so, is there any advice you can give me as a person who was looking for the same thing. Cheers!