Convert in a Decimal Value into a Duration 000:00:00 when Column Type is 'Decimal'

I have a column that includes values like 30.6, 4000, 600, etc. so the column type is set to Decimal. There is however, some values that are listed as 0.00723423 or 0.0052342 which actually denote a DURATION. How do you list these these as durations without changing the column type to DURATION (as it wold change the other values which are correctly listed)

See below example highlighted in green. This should be a DURATION, but notice the previous number is listed correctly.

I feel like this would be an IF expression. IF the value is less than 0.1, than do this calculation to covert it to a duration, ELSE, leave the value unchanged.

What do you think?

Solved Solved
0 13 1,244
1 ACCEPTED SOLUTION

Steve
Platinum 4
Platinum 4

There is no way to display a Decimal value as a Duration directly.

Instead of displaying the column you currently are, add and instead display a virtual column that renders the other columnโ€™s value in the desired way.

View solution in original post

13 REPLIES 13
Top Labels in this Space