| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to calculate speed given distance and mm:ss time format? | Excel Discussion (Misc queries) | |||
| Too many different cell format | Excel Discussion (Misc queries) | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
| protecting format | Excel Discussion (Misc queries) | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Threaded Mode
