need an average over 24 hours

[bob]

I need help in trying to set up a work sheet that will keep track of an
average. I also need to know what I have to maintain to get the average I
am looking for. Example: I need to average .075 over a 24 hour period, lets
say that I have 12 hours of data, i need to know what I have to average the
remaining hours to get my .075. I enter the hourly numbers myself.

 

[joel]

You average of 24 hours is adding 24 samples and dividing by 24

MyAverage = Sum(Range("A1:A24")/24

So you want MyAverage > .075

Now if you have 8 hours of data
MyAverage = Sum(Range("A1:A8")/8

The average you would need to maintain over the next 16 hours would be

..075 = (Sum(Range("A1:A8") + Uncollected_Data)/24

..18 - Sum(Range("A1:A8") = Uncollected_Data

Your avarage samples for the next 16 hours will be
Uncollected_Data/16