Hi,

I have the below format for a spreadsheet.

Each call centre agent can spend 00:45 minutes per hour on a call. I want to calculate in column C how many call centre agents have to be available at any given time. For example, below there should be 3 call centre agents on as it is 131 minutes and 3 agents would cover 135 minutes. However, if the time is less than 00:45 minutes I still have to have 1 agent on the line to cover calls and want the formula to reflect this.


Column A
Time
09:00:00 - 10:00:00

Column B
Average Hourly Time on calls (hh:mm)
02:11


Any help is greatly appreciated

David