title: Calculating the average percentage of a bunch of figures in Excel?
body: <p>Basically, I'm trying to calculate the total average outage hours of a worksheet I'm working with, however I'm trying to have it further broken down.</p>
  
  <p>Here is a picture of the Excel Sheet:</p>
  
  <p><strong>Excel Calculations</strong></p>
  
  <p><a href="https://i.stack.imgur.com/ltrRl.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/ltrRl.jpg" alt="enter image description here"></a></p>
  
  <p>(Not allowed to add embedded pictures yet :( - 10 reputation needed, sorry!)</p>
  
  <p>Pretty much, I'm trying to calculate what the average up-time is for the month, by calculating the average downtime and then subtracting it from 100.00%</p>
  
  <p>What I've got works, but I'm trying to workout whether the Outage Hours column can be scrapped, and the total can be calculated with perhaps just a larger formula.</p>
  
  <p>Here is a link to the spreadsheet: <a href="https://www.dropbox.com/s/msowjndootd2hh2/Spreadsheet%20Calculations.xlsx?dl=0" rel="nofollow noreferrer">https://www.dropbox.com/s/msowjndootd2hh2/Spreadsheet%20Calculations.xlsx?dl=0</a></p>
  
  <p>Thanks in advance!</p>