I've been fiddling round with this for a while and my guess is that the answer will be "can't be done" but anyhow



Pivot table date grouping allows you to choose from one of more years, quarters,months,days,hours,minutes,seconds.

Is there any way (preferably without VBA ) to group by other date/time buckets eg week , 15 minute slots (Sometimes a work-around could be to add the desired bucket to the raw data but not always possible )

Thanks in advance for your help

Grouping by week can be done with "Group by days" and set the number of days to 7.
By 15 min slots I don't think so

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thank you
Group by days ... I hadnt ever noticed that you could change the number of days
I've just tried it and it will be useful . For the other bucket types I'll stick with adding extra columns to the source data