How do you calculate uptime percentage?
Take the total time in the period, subtract the time the service was down, divide by the total time and multiply by 100. A 30-day month has 43,200 minutes, so 50 minutes of downtime gives (43,200 minus 50) divided by 43,200, which is 99.88% uptime.
How much downtime is 99.9% uptime?
0.1% of the period: 43 minutes 12 seconds in a 30-day month, 44 minutes 38 seconds in a 31-day month and 8 hours 45 minutes 36 seconds in a 365-day year.
How do I calculate uptime in Excel or Google Sheets?
Put the total minutes in one cell and the minutes of downtime in another, then use =1-B2/A2 and format the cell as a percentage. The same formula works in both. To get a month's total minutes from any date in it, use =DAY(EOMONTH(D2,0))*1440.
Does planned maintenance count as downtime?
It depends on how the figure is defined. Some service level agreements leave out maintenance that was announced in advance, but the agreement's own wording decides. Whatever you choose, apply it the same way every month and say which rule you used.
Why do uptime calculators give different downtime figures?
Mostly because they assume different month lengths. 99.9% of a 30-day month is 43.2 minutes, of an average month (365 days divided by 12) 43.8 minutes, and of a 31-day month 44.6 minutes. All three are right for their assumption. Our own calculator averages over a 365.25-day year, so its month is a twelfth of that, about 43.8 minutes at 99.9%.