Menu
Tomek's blog
  • Contact & About
Tomek's blog
A sheet of paper with numbers and a red pencil. Photo by Chris Liverani on Unsplash

Printing nicely formatted time in Google Spreadsheet

Posted on June 21, 2018November 15, 2022 by Tomek Kaczanowski

If you need to change some numbers into nicely formatted hours in Google Spreadsheet, then this article is for you.

So let us say I calculate some time in minutes and want to print it as a nicely formatted hour. This is the formula that makes it happen (where A2 is the cell number to convert):

=CONCATENATE(QUOTIENT(A2, 60), “:”, if (MOD(A2, 60) < 10, CONCATENATE(“0”, MOD (A2,60)), MOD(A2,60)))

The result looks like this:

If you know a better way to do it, let me know, please!

Share this:

  • Click to share on X (Opens in new window) X
  • Click to share on Facebook (Opens in new window) Facebook
  • Click to share on LinkedIn (Opens in new window) LinkedIn
  • Click to share on Reddit (Opens in new window) Reddit
  • Click to share on Pocket (Opens in new window) Pocket
  • Click to email a link to a friend (Opens in new window) Email
  • Click to print (Opens in new window) Print

Like this:

Like Loading...

Related Posts

  • gdocs
  • google
  • spreadsheet
  • Leave a ReplyCancel reply

    Follow me on Twitter

    My Tweets

    Subscribe to Blog

    My Books

    Practical Unit Testing - JUnit Practical Unit Testing - TestNG Bad Tests, Good Tests kanban for your team 1,2,3 kanban Złe testy, dobre testy

    Tags

    4dx agile book review capacity planning conference constraints continuous improvement daily scrum decision taking discussion effectiveness review estimation experiment facilitation feedback funny getting things done goals interview kanban leadership management management 3.0 meetings notes organisational culture procrastination productivity psychological safety rant remote work retrospective scrum scrum sprint sociocracy sociocracy 3.0 team testing tips & tricks tools transparency visualization wip work in process work in progress

    There is no Planet B. Act Now!

    There is no Planet B. Act Now!
    There is no Planet B. Act Now!

    Follow me on LinkedIn

    Tomasz Kaczanowski

    Top Posts & Pages

    • ACE! Conference 2015
      ACE! Conference 2015
    • Sociocracy 3.0 Effectiveness Review
      Sociocracy 3.0 Effectiveness Review
    • Interview Tool: Moving Motivators
      Interview Tool: Moving Motivators
    • 4DX: LAG vs. LEAD
      4DX: LAG vs. LEAD

    Categories

    • agile (32)
    • book (7)
    • event (2)
    • facilitation (2)
    • organization (11)
    • productivity (32)
    • sociocracy (10)
    • team (5)
    • testing (2)
    • tools (16)
    • Uncategorized (9)
    • varia (30)
      • remote work (2)
      • ux (2)

    No Business On A Dead Planet

    No Business On Dead Planet
    No Business On Dead Planet
    ©2025 Tomek's blog | WordPress Theme by Superb Themes
    %d