ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel Pivot Table Grouping (https://www.excelbanter.com/excel-discussion-misc-queries/157443-excel-pivot-table-grouping.html)

JohnUKMed

Excel Pivot Table Grouping
 
I have a sheet that shows how long reports take to print. Each report shows
start time in one column and another column shows how long it takes for it to
print. I can group in a pivot table and chart the average time for each
start time. IE at 8:30 5 reports print and average time is 2 min. I am able
to group by day, hour and min, but i want to group the min select in 5 or 10
min increments. IE 8:30, 8:34, and 8:35 data would be grouped togther
instead of as seperate times.

Is there a way do group min by time ranges?

Thanks,
--
John


All times are GMT +1. The time now is 05:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com