Thread: format mm:ss
View Single Post
  #1   Report Post  
Karl Lejour
 
Posts: n/a
Default 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