Need Formula to Figure Difference Between Time Periods
 

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 __%.

Need Formula to Figure Difference Between Time Periods
 

Hi,

With your times in a1 & b1 try

=(A1/B1)-1

format as %

Mike

"kbeirne" wrote:

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 __%.

Need Formula to Figure Difference Between Time Periods
 

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
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"kbeirne" wrote in message
...
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 __%.

Need Formula to Figure Difference Between Time Periods
 

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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"kbeirne" wrote:

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 __%.