Cell update

Hi,

I am looking for a macro that will average a cell value every hour. This cell is being updated every 5 seconds.

Thanks.

Bob

Hi,

OK, let me be more precise. I have a cell, A1,which value is being updated every 5 seconds from a DDE server. I wish to get an average of these updated values every each hour.
Thanks for any help.

Bob