Determine a percentage for a time duration

[mikeheathis@me.com]

My daughter is a competitive swimmer and wants to know what her times would be if she improved them by 5%. For example, her fastest time for a 200 metre free style is 2 minutes, 4 seconds and 36 one hundredths of a second (2.04.36). I'd like to build a simple calculator where she puts in her target improvement e.g. how fast would she swim if she swam 5% quicker. Any suggestions?

 

[AliGW]

To work out the time with 5% knocked off:

=A1-(A1*0.05)

You could have the 0.05 in a cell (e.g. C1):

=A1-(A1*C1)

Excel 2016 (Windows) 32 bit
[Table="width:, class:head"][tr=bgcolor:#888888][th] [/th][th]

A​

[/th][th]

B​

[/th][th]

C​

[/th][/tr]
[tr=bgcolor:#FFFFFF][td=bgcolor:#888888]

1​

[/td][td]

00:02.36​

[/td][td]

00:02.24​

[/td][td]

5.00%​

[/td][/tr]
[/table][Table="width:, class:grid"][tr][td]Sheet: Sheet1[/td][/tr][/table]

A1 needs to be custom formatted thus:

mm:ss.00

Format for C1 is percentage.

 

[mikeheathis@me.com]

Brilliant Ali ... thank you for your help!

 

[AliGW]

No problem!