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>
<colgroup><col style="width: 182px"><col width="100"><col width="43"><col width="37"><col width="109"></colgroup><tbody>
</tbody>
=(((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>