In C1 enter this formula and drag/copy down until you get an error.

=AVERAGE(INDEX(B:B,ROW(B1)*6-5):INDEX(B:B,ROW(B1)*6))

If you don't have even sets of 6 times it won't give you proper
results.


Gord

On Thu, 10 May 2012 00:17:36 +0000, contrucci
wrote:


hello all, here's the isse:

column A : time, formatted in dd/mm/yyyy mm:ss
column B : a numerical value (3.30, 3.31...)

As you can see below I have 6 of these numerical value entry per minute.
I would like to reduce them to 1 entry per minute, and this entry
should be the average of the 6 ; what do you recommend? thank
you!!

07/05/2012 00:01 3.30
07/05/2012 00:01 3.31
07/05/2012 00:01 3.33
07/05/2012 00:01 3.33
07/05/2012 00:01 3.33
07/05/2012 00:01 3.31
07/05/2012 00:02 3.34
07/05/2012 00:02 3.37
07/05/2012 00:02 3.36
07/05/2012 00:02 3.34
07/05/2012 00:02 3.34
07/05/2012 00:02 3.32
07/05/2012 00:03 3.32
07/05/2012 00:03 3.28
07/05/2012 00:03 3.28
07/05/2012 00:03 3.31
07/05/2012 00:03 3.32
07/05/2012 00:03 3.29
07/05/2012 00:04 3.29
07/05/2012 00:04 3.31
07/05/2012 00:04 3.32
07/05/2012 00:04 3.29
07/05/2012 00:04 3.29
07/05/2012 00:04 3.29
07/05/2012 00:05 3.27
07/05/2012 00:05 3.29
07/05/2012 00:05 3.31
07/05/2012 00:05 3.31
07/05/2012 00:05 3.32
07/05/2012 00:05 3.30