Pivot Table - time row

[AWulf]

Good morning,
We recently upgraded from Win7 to Win10 and i'm trying to prepare my monthly metrics report. Typcially, I extract a file from our data system, clean up the noise, and then insert a pivot table to get summary information that I need for reporting. The data has a column for date, a column for time interval (by 30 minute interval...8am, 8:30am, 9am, 9:30am, etc), and the total of calls received during that interval. In the past when I ran my pivot table, it would honor these 30 minute intervals and sum up the data within these groupings for the month. When i run my pivot table this month, it is grouping everything to the full hour. How can I format my pivot table to keep the 30 minute increments?

Thank you for your help!

 

[RandomStranger1577]

Don't know about doing it within the Pivot Table, but you could always create a column in your data and use the formula, =CEILING(B2,TIME(0,30,0))

This will let you assign 30-minute intervals and you can drop that field into the pivot table instead of grouping.

Hope that helps