I have a bunch of customer data that I'm trying to analyze, and one of the fields is "trip duration" in minutes ranging from 0 to 720 minutes. The problem I'm having is that there are too many different trip times to easily easily summarize in a pivot table. Most of the trips congregate around the 1/4 hour (i.e. 15, 30, 45, etc), so I would like to essentially "round" or "group" the durations to the quarter hour like this:
0 - 19 min = 15
20 - 35 min = 30
36 - 51 min = 45
etc.
I thought of using embedded if statements, but this formula would be really long, and there's got to be a better way. Any suggestion?
Thanks,
Dale
0 - 19 min = 15
20 - 35 min = 30
36 - 51 min = 45
etc.
I thought of using embedded if statements, but this formula would be really long, and there's got to be a better way. Any suggestion?
Thanks,
Dale
