Total hours, minutes, and seconds from Duration

AppSheet Tips & Tricks
1

New help docs for recently-added functions:

7 Likes
2

Here’s another recent post about new expressions:

[New Expressions ](https://community.appsheet.com/t/new-expressions/16709) Tips & Tricks ?

If you are still not aware, pls. checkout https://help.appsheet.com/en/articles/3483429-intersect TOTALHOURS(), TOTALMINUTES() and TOTALSECONDS() are launched but don’t have any documentation yet. [image]

1 Like
3

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
4

Kirk_Masden:

is there an easy way to take a number of seconds (342 for example) and convert it to a duration

Unfortunately, no.

Kirk_Masden:

Is this the correct approach, given the expressions that are currently available?

It’s a perfectly reasonable approach, yes.

2 Likes
5

Thanks Steve!

2 Likes