How do I enter stopwatch laptime in Excel cells, keeping seconds and minutes apart i.e. the following example:
My Stopwatch readout time was 1 minute 45 secs.
I want to enter it in an Excel cell as 1 and 45;
NOT as 1,75 or 1+ 0.75 or any decimal notion;
I want the seconds and minutes in the same cells in order to sort between different athletes