Lets say for example I have 6 durations:
mm:ss.00 4:03.2 4:08.2 4:03.1 4:06.4 4:01.3 4:03.3
And I want to find the minimum duration. How would I do that? It doesnt work if I say
I've tried using
=concatenate("00:",A1) etc etc, but it doesn't seem to work.