Hi all!
Plz help me figure out how to do this
Date Time Value
01-01-2002 08:23 603
01-01-2002 09:23 650
01-01-2002 10:23 734
01-01-2002 11:23 878
01-01-2002 12:23 986
01-01-2002 13:23 975
01-01-2002 14:23 940
01-01-2002 15:23 834
01-01-2002 16:23 611
01-01-2002 17:23 0
02-01-2002 08:23 744
02-01-2002 09:23 883
02-01-2002 10:23 951
02-01-2002 11:23 980
02-01-2002 12:23 987
02-01-2002 13:23 975
02-01-2002 14:23 885
02-01-2002 15:23 837
02-01-2002 16:23 686
02-01-2002 17:23 0
.
.for, say, 10 years. Now, * I want like this
Date Time =AVERAGE()
08:23 09:23 10:23 11:23 12:23 13:23 14:23 15:23 16:23 17:23
01-01-2002 603 650 734 878 986 975 940 834 611 0 .
02-01-2002 744 883 951 980 987 975 885 837 686 0 .
.
.
Bookmarks