Perhaps simplest to just use Excel's inbuilt Subtotal functionality:
The other alternative would be to use a Pivot Table to analyse the DataHighlight A:H and apply Data -> Subtotal as follows:
At Each Change In: Half Hour
Use Function: Sum
Add Subtotals To: Calls, Abandoned Calls, Avg Speed of Answer, Avg Abandoned Time
Bookmarks