Time Average

[Zeus Ex]

Hello,
I have attached a file with this question.
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.

[shg]

In B1 and copy down,

=AVERAGE(INDEX(A:A, 4*ROWS(A$1:A1) - 3):INDEX(A:A, 4*ROWS(A$1:A1)))

[Zeus Ex]

Thanks shg

[Zeus Ex]

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]

Someone?

[shg]

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

What does that mean?

EDIT: Maybe this ...

Put the value 1 in a cell and copy. Select A463 through A1220, Past > Paste Special, tick Add and Values

[Zeus Ex]

Hi,

I have attached a file here which explains my problem.
In the first graph you will notice that data from row 116 are getting plotted before previous ones.
Here excel doesn't understand that date has been changed already.
In the second graph please notice that I added date manually in column O and I also had to change date to 22nd from row 116. This way excel plots the desired curve.
And this is what I want in an efficient way.

Thanks a lot for help.

[shg]

Did you try my suggestion?

[Zeus Ex]

Thanks. It is working.

One last help.
In the same file I attached here


14:48:32 35.43456053
14:53:20 25.07797526
14:58:08 20.05618611
15:02:56 16.41844629
.
.
.

Is it possible to have time and values like this in Excel?
14:50:00 calculated value
14:55:00 calculated value
15:00:00 calculated value
and so on.

Regards,