Skip to main content

All Questions

0 votes
1 answer
2k views

How to group timestamp in the format yyyy-MM-dd'T'HH:mm:ssZZZZ into buckets of 15 minutes in excel?

I need to find the number of records (pid) in the interval (buckets) of 15 minutes for a year long data. Normally when MM/DD/YY H:MM AM, you just pivot the data, put timestamp into row, click on group ...
Hemanth Ravavarapu's user avatar