Hi Guys, thanks for the suggested solutions, but I need a return in Time format instead of text.
I have tried a whole bunch of possibilities online, but no solutions that works.
Value in the column, for example: 0,1667 => that is 10 minutes
I have added a new column with a formula:
xx_starting_time_reformat = FORMAT(TIME(TRUNC(KPI_ODOO_account_analytic_line[xx_starting_time],0),(KPI_ODOO_account_analytic_line[xx_starting_time]-TRUNC(KPI_ODOO_account_analytic_line[xx_starting_time],0))*60,0),"long time")
The formula works great to convert time from decimals to time format, but it won't work when I use it for duration, especially when it is less then 1 hour.
Error: An argument of function 'TIME' has the wrong data type or the result is too large or too small.
