This seems like an algebra question, not an Excel question. (Although there
could be an Excel question behind it.)

In general, if you have n of 24 hourly data, h[1] through h[n], then you are
looking for x, the average remaining hourly data, such that:

( h[1] + ... + h[n] + (24-n)*x ) / 24 = 0.075

So:

x = ( 24*0.075 - (h[1] + ... + h[n]) ) / (24-n)

In Excel terms, if A1 contains the target average (0.075) and if B1 up to
B24 contain the hourly data that you have, then:

=(24*A1 - SUM(B1:B24)) / (24 - COUNT(B1:B24))


----- original message -----

"bob" wrote:
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.