Hi I have some data that I would like to convert from a 1 min data into groups of 5 mins starting from 00:00, 00:05, 00:10 etc it is occuring over a number of years that is spread over 4 worksheets (yea its a lot of data). Problem is that it isn't a continuous set of 1 min data as it is only recorded when an event occurs.
I would like to show the start price, end price and the highest and lowest prices during that period as well.
Can anyone help me on this?
It's the price of the Australian Dollar since 2/1/2001
Much appreciated and thank you in advance.

My data looks like this:
Time is HHMMSS
Date is YYYYMMDD