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




Be the first to comment

Leave a Reply