Skip to main content

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, E‘input format’], f‘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!

The easiest way is to use this formula


{Minutes}*60

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


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’)


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’)


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

Reply