SUM Bins of Data

M

mluetkem

Anyone know how to sum bins of data, sort of consolidating. I have a
column of per minute data that I need to consolidate down to per
10-minute bins, so for each 10 rows of per minute data would create a
single row of 10-minute data.

Thanks.
 
D

Dave Peterson

Maybe you could use a helper column.

=CEILING(A1,1/24/6)

[=CEILING(A1,1/24/60) will round up to the nearest minute. So I multiplied by
10.]

Will round up the time in A1 to the nearest 10 minutes.

Then you could use a pivottable to summarize this or even Data|Subtotal?????
 
Top