Total hours, minutes, and seconds from Duration

New help docs for recently-added functions:



7 Likes

Here’s another recent post about new expressions:

1 Like

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?

1 Like

Unfortunately, no. :frowning:

It’s a perfectly reasonable approach, yes. :slight_smile:

2 Likes

Thanks Steve!

2 Likes