10% Time Improvements

colinshu

New Member
Joined
Sep 13, 2019
Messages
3
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 SportMinSecNew Goal
Student 1Soccer7056.38
Student 2Soccer6576.26
Student 3Soccer8017.22
Student 4Soccer7006.30
Student 5Soccer6596.29
Student 6Soccer6035.45
Student 7Soccer7005.92

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

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,706
Decimal time...??
Code:
=TIME(0,7,5)*0.9
Format as "H:MM:SS" or "MM:SS"

Code:
TIME(0,C2,D2)*0.9
 

Watch MrExcel Video

Forum statistics

Threads
1,099,472
Messages
5,468,823
Members
406,611
Latest member
hanman453

This Week's Hot Topics

Top