This is probably one of the more stupid/simple questions to come up on these boards but I just can't figure it out.
I want to use a spreadsheet to track my jogging times, to be exact I want to insert the time for each lap, sum them up and then compare the result against a points system.
The problem is that I just can't quite figure out how to enter times in minutes and seconds into Excel. Say for example I want 2:15 to mean 2 minutes and 15 seconds. I went into Format Cell->Custom and there was a format setting for "mm:ss" which I thought would be just what I was looking for.
However upon formatting a cell into that format and inserting 2:15, it shows me 2:15:00 even though the format setting I have chosen shouldn't leave an option open for hours to be shown. Now I noticed that if I were to type in 0:2:15 then it would show up as 02:15 which is a bit closer to what I want but its still slightly annoying to type that extra superfluous "0:" in front of every time I want to enter.
So in short: what can I do to Excel to make it think that when I'm entering 2:15 into a cell, it stands for 2 minutes and 15 seconds and not something else?
I want to use a spreadsheet to track my jogging times, to be exact I want to insert the time for each lap, sum them up and then compare the result against a points system.
The problem is that I just can't quite figure out how to enter times in minutes and seconds into Excel. Say for example I want 2:15 to mean 2 minutes and 15 seconds. I went into Format Cell->Custom and there was a format setting for "mm:ss" which I thought would be just what I was looking for.
However upon formatting a cell into that format and inserting 2:15, it shows me 2:15:00 even though the format setting I have chosen shouldn't leave an option open for hours to be shown. Now I noticed that if I were to type in 0:2:15 then it would show up as 02:15 which is a bit closer to what I want but its still slightly annoying to type that extra superfluous "0:" in front of every time I want to enter.
So in short: what can I do to Excel to make it think that when I'm entering 2:15 into a cell, it stands for 2 minutes and 15 seconds and not something else?