Posted to microsoft.public.excel.worksheet.functions

Bec[_3_]

external usenet poster

Posts: 12

Averages

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
30, 60 or 90 day averages	Bendleton	Excel Worksheet Functions	3	December 22nd 06 08:34 AM
Averages	Zygy	New Users to Excel	16	June 19th 06 10:01 PM
Averages	alexfthe	Excel Worksheet Functions	1	March 11th 06 10:58 AM
Averages	Beth	Excel Worksheet Functions	0	March 10th 06 03:33 PM
Averages	Jimenda	Excel Worksheet Functions	1	December 21st 05 11:24 PM

All times are GMT +1. The time now is 09:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us