Time Average

[zeus ex]

Hello,

I have attached a file with this question.

http://www.megaupload.com/?d=N82FD2WX

In this file Col A represents time. I am trying to take time average in the group of 4.

I mean B1 is the time average of A1:A4, B2 is avg of A5:A8, B3 is avg of A9:A12 and so on.


How can I do the same for whole range?


Please help.


Thanks.

 

[oldchippy]

Hi,


Try this


=AVERAGE(OFFSET(A$1,ROWS(D$1:D1)*4-4,,4))


Format cell to TIME

 

[zeus ex]

Thanks oldchippy.

I have another question.

In Col A, day is changing from A463.

What is the best way to tell excel that it is a new day?

This is an issue because if I try to plot something vs. time, excel doesn't automatically add a next day rather starts plotting from beginning.


Thanks.

 

[zeus ex]

Your help will be greatly appreciated.