New help docs for recently-added functions:
Hereโs another recent post about new expressions:
Thanks for this useful post, @Steve! Is there a simple way to go in the other direction? That is, is there an easy way to take a number of seconds (342 for example) and convert it to a duration that can be displayed in the normal minutes : seconds format? Hereโs what I came up with to display seconds with totals under an hour in minutes : seconds format:
concatenate(
floor([seconds]/60),":",
left(โ00โ,2-len(text(MOD([seconds],60)))),
MOD([seconds],60)
)
Is this the correct approach, given the expressions that are currently available?
Unfortunately, no.
Itโs a perfectly reasonable approach, yes.
Thanks Steve!