contrucci pretended :
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
<FWIW
This looks very much like a custom report generated by data logger
software. If so, that same software should be able to do this
(depending on the quality of the data logger product). If it's raw data
then the controller should be able to be reconfigured to generate
avg/min!
--
Garry
Free usenet access at
http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.
vb.general.discussion