Thread: format mm:ss

Hello,

I have lap times in minutes and seconds. When I type 3:05 (= 3 minutes 5
sec), excel records 3:05:00.
How can I type directly in a cell mm:ss without having to add 00: for the
hours?
I tried to format the cell, without succes

FORMAT->CELL->CUSTOM
CHOOSE mm:ss->CLICK ON OK
HOPE IT WILL WORK 100%

"Karl Lejour" wrote:
>
> Hello,
>
> I have lap times in minutes and seconds. When I type 3:05 (= 3 minutes 5
> sec), excel records 3:05:00.
> How can I type directly in a cell mm:ss without having to add 00: for the
> hours?
> I tried to format the cell, without succes

You can't. When Excel sees 3:05, it assumes hours and minutes. Just one of the
defaults the Excel programmers chose which doesn't work for you. You could enter
3:05 in one cell, and have a helper cell which divides this by 60, that will
convert to mm:ss for you.

--
Regards,
Fred


"Karl Lejour" <Karl Lejour@discussions.microsoft.com> wrote in message
news:1365E041-0107-4222-BC98-145587CD1990@microsoft.com...
>
> Hello,
>
> I have lap times in minutes and seconds. When I type 3:05 (= 3 minutes 5
> sec), excel records 3:05:00.
> How can I type directly in a cell mm:ss without having to add 00: for the
> hours?
> I tried to format the cell, without succes