Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
need an average over 24 hours
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
need an average over 24 hours
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 "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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working hours average | Excel Discussion (Misc queries) | |||
Sum and average number of days and hours | Excel Discussion (Misc queries) | |||
Drivers Hours Timesheet - Calculate Hours Worked on Weekly Basis | Excel Discussion (Misc queries) | |||
calculate average hours and minutes | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions |