Aggregating timestamped data up to half hourly totals

I have a worksheet containing one timestamp column and a single column of data, the interval being one minute. How can I aggregate it to get half-hourly totals?

Thanks, Andy

Here's a sample workbook to illustrate what I'm trying to do.

Originally Posted by andykent99

Here's a sample workbook to illustrate what I'm trying to do.

Dear Andykent,

I have solved your problem, and I attached your sample file with solution.

If you want more clarification, I always welcome to you.

And I feel pleasure to help to you, and through this I learn much from it.


Thank You.


Muhammad R.
[email protected]