Substracting from 100%

[MrDosey]

Hello!

I have a list of computer system down time tracked in % of time with a 24 hours period. The following is an example:

System Name Down Time Date

Application X 100.00% 01/01/2018
Application Y 2.50% 01/02/2018
Application M 40.00% 01/03/2018

I need to convert that list into an Available time report instead of a down time report. For that I would need to create a formula that would give the difference of the down time metric from a 100%. For example Application Y will need to read an up time of 97.5% and for application M will need to read 60.00%.

Can you help me create such formula?

Thank you!

 

[mikerickson]

If the down time is in A1, the formula =1-A1 will give you the avaliable time.

 

[MrDosey]

Thank you, very much! Simple and elegant.