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.

Any advice?

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.

Thanks