Inside of a spreadsheet I have, there is a duration formatted column where I do hand entered data a few times per day. This works well for my purposes, but an annoying problem that I face is that these durations are for more often than not under 1 hour long, yet sheets formats my input under the hours mark instead of minutes. For this reason, I would like the hour insertion to be the exception, not the rule.


  • I type in 12:45
  • The entry I want is 00:12:45
  • Sheets arranges it to 12:45:00

Current solution:

  • I have to manually type in 00:12:45 rather than be able to use auto complete.

This is not a world breaking issue, but I would rather not have to type the extra 00: a few times every day. I have already tried to remove the hour zone from the formatting entirely, but that removes the hour data from the entire column.

  • 1
    Welcome to Web Applications Google Sheets handle dates-time like values according to the spreadsheet region. I don't know if there is one region having the duration format that you want but changing the region might have some undesired side effects. Are you looking for a built-in feature based solution? Are you open to use Google Apps Script? Also please add a brief description of your research efforts as is suggested in How to Ask.
    – Rubén
    Sep 7, 2021 at 16:38
  • 1
    Related 1, 2, 3
    – Rubén
    Sep 7, 2021 at 16:40


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.