This is a discussion on Formatting a cell for swim times within the Excel Questions forums, part of the Question Forums category; I have been trying to format a cell for swim times: mm:ss:## the ## needs to be a number between ...
I have been trying to format a cell for swim times: mm:ss:## the ## needs to be a number between 00 and 99. I have tried customizing etc, but I really don't know what I'm doing. Can anyone help?
You are almost there.
Got to Format=>Number=>Custom and set up the format as mm:ss.00
You can then enter a time of 1 min 15.83 secs as 1:15.83 and that is how it will display.
Internally, Excel will still store it as fractions of a day and in the formula bar is will show as 00:01:16
Any calculations carried out, will add (or subtract) the decimal seconds you have entered correctly.
Technology 4 U