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