Time improvement percentages

Formula question: If I have a list of times from races, how do I determine the percent improvement? Example (minutes, seconds, milliseconds) race 1 - 30:00.607, race 2 - 28:36.055, race 3 - 25:30.000 how do I display the percent improvement from the first to third race. There is about a 4 minute 30 second improvement in this example but sometimes there are no improvements or even a gain in time. If it were a gain, meaning it took longer, I think it should show as a negative (I’m not sure).

Posted on Nov 8, 2023 6:49 AM

Reply
Question marked as Top-ranking reply

Posted on Nov 8, 2023 7:41 AM

If your table looks like that one, that formula is the answer:


Enter in C3, then copy down

=(B$2−B3)÷B$2




If the duration format is not as you wanted, use a custom format


1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Time improvement percentages

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.