Help

Re: Transform integer minutes into hh:mm

1120 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Dan_Dreschler
4 - Data Explorer
4 - Data Explorer

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!

3 Replies 3

The easiest way is to use this formula

{Minutes}*60

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

Dan_Dreschler
4 - Data Explorer
4 - Data Explorer

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