Need Formula to Figure Difference Between Time Periods

[kbeirne]

I want to find the percentage improvement from a pre-test (time kid A runs 1
mile) to a post-test (time kid A runs one mile later).
Times were entered as 5.22 (5 minutes and 22 seconds).
I've converted them to a 00:05:22 format.
How can I find percentage difference if kid A runs the mile in 00:05:22 to
start and 00:05:01 six weeks later? Kid A improved their time by __%.

 

[Mike H]

Hi,

With your times in a1 & b1 try

=(A1/B1)-1

format as %

Mike

 

[Bernard Liengme]

All percentage changes are computed using
=Change/Original
OR =(New-value - Old-value)/Old-value
With Old-time in A1, new time in B1, use =(B1-A1)/A1 and format the cell
Percentage
I get 6.5%
best wishes

 

[Shane Devenshire]

Hi,

There is no need to convert or change the format, in any case the formula
would be something like

=(B5-B6)/B5

where B5 is the earlier result and B6 the later.