![]() |
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