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