Forum Discussion
Enter Time as mm:ss only
As variant you may enter (let say in cell A1) 12:34 which is actually 12 h 34 m, but in all calculations use =A1/60 which returns 12 m 34 s
Joe_Gandalf....
Would it be acceptable to enter data in the form mm:ss.0?
Excel always interprets the form 12:34 as 12h 34. But 12:34.0 is interpreted as 12m 34.0s.
(Note: The format of the cell before data entry does not change how data entry is interpreted. It only changes the appearance of the result.)
And of course, you can enter non-zero fractional seconds, e.g. 12:34.567890123. But Excel rounds to the 1/1000 second (millisecond); seconds with 3 decimal places.
In any case, you might want to choose a Custom format that differs from the default that Excel chooses for times that are entered in form 12:34.0.
- mm:ss.0 would be a bit simpler than 0:mm:ss, but it won't allow me to import some existing data that is in mm:ss .
