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?