Pivot Table Time period filter

[shonaart]

Hi
In pivot table ( Excel 2010 ) you have the option to select Dates periods etc on the DATE FILTER. There are a number of option you have to select different dates and periods.

How can i have the same for TIME , my one column in the Pivot table has time ie 13:30 and and I want to select the times ( in the pivot table ) for example all the times that are from 06:00 to 14:00.

Note that there is no Dates on the times column.

The date works great but there is nothing for time .

Thanks
Vaughan

 

[Herbert Seidenberg]

Excel 2010
To filter for time periods
change Date Filters to Label Filters.
http://c3017412.r12.cf0.rackcdn.com/04_20_11.xlsx
If you get *.zip, don't unzip, just rename *.xlsx