Transform integer minutes into hh:mm


#1

Hello! Please help.

I would like to transform (through “Formula”) integer minutes number into hh:mm. Can you help me build “Formula”, please? I still can not build it.

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

I tried different combinations, but in vain:

DATETIME_PARSE(date, [‘input format’], [‘locale’])
DATETIME_FORMAT(MINUTE({Odpracováno copy}), ‘H:mm’)
DATETIME_PARSE(MINUTE({Odpracováno copy}), ‘H:mm’)
DATETIME_PARSE(MINUTE({Odpracováno copy}))
DATETIME_PARSE(56, ‘mm’)
DATETIME_FORMAT(IF(Minutes < 1, CREATED_TIME(), DATEADD(CREATED_TIME(), Minutes - 1, ‘minute’)), ‘MM-DD-YYYY hh:mm a’)
DATETIME_FORMAT(IF({Odpracováno copy} < 1, {Odpracováno copy} - 1, ‘minute’)), ‘H:mm’)
DATETIME_FORMAT({Odpracováno copy} - 1, ‘H:mm’)
DATETIME_PARSE({Odpracováno copy}, ‘mm’)

Thank you!


#2

The easiest way is to use this formula

{Minutes}*60

and format the result as a Duration of h:mm type.


#3

I tried different combinations, but in vain:

DATETIME_PARSE(date, [‘input format’], [‘locale’])
DATETIME_FORMAT(MINUTE({Odpracováno copy}), ‘H:mm’)
DATETIME_PARSE(MINUTE({Odpracováno copy}), ‘H:mm’)
DATETIME_PARSE(MINUTE({Odpracováno copy}))
DATETIME_PARSE(56, ‘mm’)
DATETIME_FORMAT(IF(Minutes < 1, CREATED_TIME(), DATEADD(CREATED_TIME(), Minutes - 1, ‘minute’)), ‘MM-DD-YYYY hh:mm a’)
DATETIME_FORMAT(IF({Odpracováno copy} < 1, {Odpracováno copy} - 1, ‘minute’)), ‘H:mm’)
DATETIME_FORMAT({Odpracováno copy} - 1, ‘H:mm’)
DATETIME_PARSE({Odpracováno copy}, ‘mm’)


#4

Again, my previous message was complete.

If you want to display {Minutes} in hh:mm format

  1. Create a formula field with this definition:

    {Minutes}*60
    
  2. In the field configuration screen, click the ‘Formatting’ tab.

  3. Under ‘Format’, choose ‘Duration’.

  4. Under ‘Duration Format’, choose ‘h:mm’.

Is “Odpracováno” in hours or minutes? If hours, change the formula above to

{Minutes}*3600