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
You need to format the cells / range or worksheet the way you want.
Steps:
Select Cells / Range or Entire Worksheet Right mousekey
Format cells ...
Format cells window Custom Enter
"[mm]: ss" (without goosefoot) or let the link show you the options.
Format numbers as dates or times
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.