Dueling Excel 84


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

DESCRIPTION

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

WORKBOOKS