Philippe Hébert
04/29/2022, 4:34 PMCAST(TIME(CAST(FLOOR(SUM(minutes) / 60) AS INT64), MOD(SUM(minutes), 60), 0) AS STRING)
-- OR
CAST(CAST(FLOOR(SUM(minutes) / 60) AS INT64) AS STRING) || ':' || CAST(MOD(SUM(minutes), 60), 0) AS STRING)
I couldn't find string operators or MOD operator in MAQL. I may just have missed them 😅
Thanks!Jan Rehanek
04/29/2022, 4:45 PMFormat blocks can be parameterized in the following way:
div - the argument that divides the input number.
mod - the modulo calculated from the result of the div calculation.
--
{{{86400||#}}} days\, {{{3600|24|00}}}:{{{60|60|00}}}:{{{|60.|00.000}}} hours
Gives the following results
120523.521 1 days, 09:28:43.521 hours
34123.521 0 days, 09:28:43.521 hours
Philippe Hébert
04/29/2022, 4:58 PM{{{60||0}}}h {{{|60|00}}}min
Thanks!Jan Rehanek
05/02/2022, 7:48 AM