Skip to main content

Integer minutes into hh:mm

  • March 6, 2018
  • 1 reply
  • 26 views
T

Hello, please help

I would like to transform (through “Formula”) Integer minutes into hh:mm. Help me build “Formula”, please.

Example: 297 min = 4 hr 57 min = 04:57

Thank you!

    1 reply

    M
    Forum|alt.badge.img+12
    • Matt_Bush
    • Inspiring
    • March 6, 2018

    You can use the built-in duration formatting option for formulas. See “Durations in computed fields” in this article.

    Since the duration formatting expects a value in seconds, you’ll want to multiply your value in minutes by 60 in the formula.

      Terms & ConditionsAccessibility statement