Forum Discussion
Solved
Convert decimals to a time column
Hello, I already tried a many solutions suggested, but still no success. I have a column with the values of time trackings, expressed in decimals: example: 0,1667 = 10min My new column: xx_st...
Hi laurent_dec
Does this help?
xColumn = FORMAT( [xx_starting_time] / 24, "long time" )Also, look for blank or negative values in the different parts of your column definition as that will raise the error you received.
grantsamborn
Solution Sage
Solution SageHi laurent_dec
Does this help?
xColumn = FORMAT( [xx_starting_time] / 24, "long time" )
Also, look for blank or negative values in the different parts of your column definition as that will raise the error you received.
Hi grantsamborn , thank you so much, works perfectly and super simple. You don't wanna know what complex formulas I have tried :). 🙏🏻