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).


Be the first to comment

Leave a Reply