What Excel formula should I use to calculate the network uptime by percentage (ie 99.999%)?

I have a list of days in an excel file in a column displaying the number of minutes we were down for each day. I need to calculate the uptime percentage, as in 99.999%, for the sum for that month. Please help.



Thank you,

jmelikaWhat Excel formula should I use to calculate the network uptime by percentage (ie 99.999%)?
One problem is that the number of days in each month varies. So the Uptime percentage will very slightly from month-to-month even with the actual down time being the same.



Here's a formula that will calculate the number of days in the month and then calculate the uptime percentage based on that.



Assume that column A has your dates and column B has your down time minutes for a given month. The numbers in column B are assumed to be just numbers and not formatted as Time.



=(1-SUM(B:B)/(DAY(DATE(YEAR(A1),

MONTH(A1)+1,1)-1)*1440))*100



The formula uses the month and year from the date in A1 to calculate the number of days in that month. It doesn't matter what the Day is in that date.



FYI: When Excel sees the "Day" function in a formula, it could try to autoformat the cell as a "Date". If it does, you will have to change the cell format back to a Number or a Percentage. If you do format the result as a percentage, remove the *100 from the end of the formula.What Excel formula should I use to calculate the network uptime by percentage (ie 99.999%)?
i can do it in 2 functions with 2003 excel.

column would be:

=sumproduct(a2:a100/1440) then

referance the above answer as such assuming your answer is in block a1:



=sumproduct(100 - A1)

travel trailers

luigi games