format mm:ss

G

Guest

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
 
F

Fred Smith

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatting cells for minutes:seconds 1
How do I convert time as text 'mm:ss to time value in Excel 5
Formating seconds into mm:ss 4
Custom format mm:ss 3
mm:ss keeps changing to a date format 6
Formatting cells 5
How to type format time in decimal format & calculate 1
How to type format time in decimal format & calculate time 1

Top