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?