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