I am trying to compile results from a series of timed events and am looking for a way to add and subtract split times that are recorded in minutes:seconds.tenths. Ex: 12:23.6
In Excel I would format these times as mm:ss.0, but I am struggling to figure this out in Panorama.
Ultimately I want to:
- Add multiple split times to create a total time for each record.
- Use running difference to indicate the time difference between successive records.
- Number the results sequentially with an allowance for ties (ex: 1, 2, 3, 4, 4, 6 where the 4th place finishers had the same exact time).
But for starters, I’d be happy to figure out how to format my “times” as a number or time in the mm:ss.0 format.