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.
Hello Sahir_Maharaj ,
Thanks for your feedback.
The time format for the decimale is like this:
Another example: 1,1667 = 1 hour and 10 minutes
So, before the comma are the hours, simple.
After the comma are the minutes, but on a scale of 100 instead of 60.
In your formula, don't I need to substract the 1 before the comma?
Thanks, Laurent.
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 :). 🙏🏻