Total hours, minutes, and seconds from Duration

Steve · 12-09-2019 11:22 AM

New help docs for recently-added functions:

Kirk_Masden

Here’s another recent post about new expressions:

Kirk_Masden

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?

Steve

Unfortunately, no.

It’s a perfectly reasonable approach, yes.

Grant_Stead

Thanks Steve!