10% Time Improvements

[colinshu]

I am trying to use a formula to calculate 10% time improvements on my student's mile run times. I came up with a workaround to split the minutes and seconds into different cells, convert them into total seconds, multiply by .90, then divide by sixty to get Min.Sec. Not fully working though as I am getting results such as 5.92...

=(((C2*60)+D2)*0.9)/60
=(((minutes*60)+seconds)*0.9)/60


<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>[TABLE="width: 0"]
<colgroup><col style="width: 182px"><col width="100"><col width="43"><col width="37"><col width="109"></colgroup><tbody>[TR]
[TD]Name [/TD]
[TD="align: center"]Sport[/TD]
[TD="align: center"]Min[/TD]
[TD="align: center"]Sec[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CFE2F3]#CFE2F3[/URL] , align: center"]New Goal[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] "]Student 1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] , align: center"]Soccer[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] , align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] , align: center"]05[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CFE2F3]#CFE2F3[/URL] , align: center"]6.38[/TD]
[/TR]
[TR]
[TD]Student 2[/TD]
[TD="align: center"]Soccer[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]57[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CFE2F3]#CFE2F3[/URL] , align: center"]6.26[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] "]Student 3[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] , align: center"]Soccer[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] , align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] , align: center"]01[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CFE2F3]#CFE2F3[/URL] , align: center"]7.22[/TD]
[/TR]
[TR]
[TD]Student 4[/TD]
[TD="align: center"]Soccer[/TD]
[TD="align: center"]7[/TD]
[TD="align: center"]00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CFE2F3]#CFE2F3[/URL] , align: center"]6.30[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] "]Student 5[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] , align: center"]Soccer[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] , align: center"]6[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=EFEFEF]#EFEFEF[/URL] , align: center"]59[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CFE2F3]#CFE2F3[/URL] , align: center"]6.29[/TD]
[/TR]
[TR]
[TD]Student 6[/TD]
[TD="align: center"]Soccer[/TD]
[TD="align: center"]6[/TD]
[TD="align: center"]03[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=CFE2F3]#CFE2F3[/URL] , align: center"]5.45[/TD]
[/TR]
[TR]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F4CCCC]#F4CCCC[/URL] "]Student 7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F4CCCC]#F4CCCC[/URL] , align: center"]Soccer[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F4CCCC]#F4CCCC[/URL] , align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F4CCCC]#F4CCCC[/URL] , align: center"]00[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=F4CCCC]#F4CCCC[/URL] , align: center"]5.92[/TD]
[/TR]
</tbody>[/TABLE]

 

[SpillerBD]

Decimal time...??

=TIME(0,7,5)*0.9

Format as "H:MM:SS" or "MM:SS"

TIME(0,C2,D2)*0.9

 

[colinshu]

Decimal time...??

=TIME(0,7,5)*0.9

Format as "H:MM:SS" or "MM:SS"

TIME(0,C2,D2)*0.9

That seemed to do it! Thank you!