in reply to Calculate hourly averages

It also occurs to me that you could stuff this into an SQL table and GROUP BY an expression that discards minutes.   Or, you could write a stub Perl script that pre-processes the data for such a purpose.   I make this suggestion on the basis that, “you might wish to get to SQL-land as soon as you can, for other reasons.”

Replies are listed 'Best First'.
Re^2: Calculate hourly averages
by addyrocker (Initiate) on Oct 20, 2010 at 13:02 UTC

    Thank you all for your valuable input it has really given me a lot to think about especially in terms of the different ways it can be done, will also give the SQL way a try thanks again!