Hi @ampersandee,
At first, I knew this would take a little work, because like @Bill_French mentioned, we’re having to mix Text and Numbers and have the end result display like text but act like a number. It was a fun brainteaser and I wanted to see if I could find a way to make it work.
Some of the challenges aside from calculating the data in minutes and seconds were sorting since minute differences might be different than seconds differences, displaying a “+” or “-” to show whether this a current race was faster or slower than a Personal Record, and being able to use columns for various things like conditional formatting.
There may be some ways to simplify this setup, but I left it as is because it’s easier to pick apart when it’s broken down into smaller chunks.
Let me know if this is at least a solution you were looking for…even if it is a little in depth.