All Questions
1
question
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 ...