Display HH:MM:SS with duration in numberFormat in a table

[Harry_O_Brien]

So I have a table where one of the columns is 'Duration', it is the difference between 2 timestamps. My value is a minute in base 10, so 30 seconds is 0.5, a minute is 1, 20 minutes is 20, 20 seconds is 0.33 etc etc. I want to display this in HH:MM:SS format but when I select 'duration' from the dropdown below it only gives it in DD:HH:MM format.

These are the options for the 'numberFormat' dropdown on the column of the table in Perspective Property Editor

This is the value after I select duration.

This is how my column renders, in DD:HH:MM format. Anything less than a minute renders as 00:00.

And here is the same data when I select 'number' in the numberFormat dropdown

How can I display this info in HH:MM:SS format?

Thanks

[pascal.fragnoud]

I think the duration format expects an integer representing seconds, not a float representing minutes, and it is actually HH:MM:SS.
Could you try multiplying the values in that column by 60 ?

[Harry_O_Brien]

Thanks for this, I will try this and report back