Forum Discussion
Solved
VERY NEW to EXCEL
How do i create a formula to Average blocks of time? I input the units for each block of time and i can get the Average after 8 hours, but i need a running average of each block of time though out ...
- Thank you very much, your help is greatly appreciated.
I will let you know how it turns out.
Dale
I attached an example workbook of what I think you're trying to do. I split the start time, end time, and hours into separate cells, added a formula to compute the hours, and added a formula to compute the UPH.
You could hardcode the hours instead of using a formula, but I would at least put the hours in a separate cell. Also, note that I used a custom number format to add the "Hrs" label - it is not actually part of the cell contents as that would cause an error in the UPH formula.
One thing, after looking at the formula it's actually 8 hours work day not 8.5, its the time when i input the numbers ,that throw me off, there 2 hour blocks.