If your project displays durations in seconds, you can use the Format Duration computed column.
How to create Format Duration columns
- 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.
The plus symbol will append the column to the end of the table. To place the new column in a specific order, click on the dropdown button in the column header next to where you want to place it, and then click Add column right.
- Give the new column a name.
- In the Type dropdown, choose Other from the list of computed columns, then select Format Duration under the Date & Time section.
- Under Seconds, enter a custom value, or select a column from your data source to use as the value for the number of seconds you’d like to format.
- Under Format, enter a custom value, or select a column from your data source to use as the format style.
Updated 5 days ago