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>

Name	Sport	Min	Sec	New Goal
Student 1	Soccer	7	05	6.38
Student 2	Soccer	6	57	6.26
Student 3	Soccer	8	01	7.22
Student 4	Soccer	7	00	6.30
Student 5	Soccer	6	59	6.29
Student 6	Soccer	6	03	5.45
Student 7	Soccer	7	00	5.92

<colgroup><col style="width: 182px"><col width="100"><col width="43"><col width="37"><col width="109"></colgroup><tbody>
</tbody>

 

[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!