Format Duration
Format a duration from seconds into hh:mm:ss.
If your app displays durations in seconds, you can use the Format Duration computed column to convert the duration into hours, minutes, and seconds.
Creating a Format Duration Column
Creating a Format Duration Column
In the Data Editor, open the table you want to edit.
Add a new column by clicking the plus (+) symbol to the right of the table.
- New columns added with the plus button will always appear on the right of the table. If you’d like to add a column somewhere else in your data, you can select the dropdown menu on an existing column and choose Add column right. You can also click and drag columns to rearrange them.
For Type, search for Format Duration or navigate to Computed → Experimental → Date & Time → Format Duration.
For Seconds, enter a custom value or select a column from your data source that contains the value for the number of seconds you’d like to format.