Forum Discussion
Solved
Enter Time as mm:ss only
I want to be able to enter the elapsed time for music files for a radio show I produce. Right now I have to enter "0:mm:ss" (songs don't last longer than 18 minutes max). Since I often import similar...
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
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
Your suggestion might be my best bet (if it isn't possible to create a custom format that will do what I want!). At least your method will allow me to import data that is already in mm.ss format.
Thanks!
