I am writing results for a cycling time trial in an Excel table. I want to
display each result as minutes and seconds eg 29:21 means 29 minutes and 21
seconds, not 29 minutes and 0.21 of a minute (base 60, not decimal).
OK, so I look in cell formatting and Excel help and am told to use the code
[mm]:ss. When I apply this, though, the cell treats the number as though it
were 29.21 days and then displays it as 42062:24 (minutes). Obviously this is
not what I want - so how do I get what I do want?
Thanks!