Hi have a spreadsheet which has lines for every minute of the day

20/8/07 1900
20/8/07 1901 etc etc for a number of weeks.

How do I easily find the average of each 15 minute period without having to
copy and paste an average formula every 15 lines? and so it's in one table
(ie no gaps)

TIA
Bec