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!