This question already has an answer here:
I'm working on this spreadsheet, and I wish to convert the data in columns C, D, and E from hours and minutes to minutes and seconds.
For example, an inputted
7:08 turned into
07:08:00.000 (hours and minutes, no seconds) when it should be something like
00:07:08.000 instead (minutes and seconds, no hours).
Is there a way to change how Google Sheets to input time by default so that a duration inputted as
mm:ss is automatically turned into