Integer minutes into hh:mm


#1

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!


#2

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.