Dueling Excel 84

Count Calls Every 15 Minutes Count Times Between Upper & Lower Limit


See Mr Excel and excelisfun use two methods to count calls every 15 minutes:
1. a PivotTable and a Helper Column using the INT function
2. COUNTIFS or COUNTIF functions and an upper and lower Limit for each 15 minute period (Count Between two Times).