Excel Pivot Tables -- Divide Numerical Column Data into Ranges
- by ktm5124
Hi,
I have an Excel spreadsheet with a column called "Time Elapsed" that stores the number of days it took to complete a task.
I would like to make a pivot table out of this spreadsheet where I divide the "Time Elapsed" column into ranges, e.g.,
how many tasks took 0 to 4 days to complete
how many tasks took 5 to 9 days
how many took 10 to 14 days
how many took 15+ days
Do I have to create new columns in my spreadsheet dedicated to each interval (0 to 4, 5 to 9, etc.) or can I use some feature of pivot tables to separate my one "Time Elapsed" column into intervals?
Thanks in advance.