You’re offline. This is a read only version of the page.
4
Hi All,
I am trying to convert a column which has value stored as decimal hour to hh:mm format.
For eg:
2.78 - 02:46
25.56 - 25:33
Also attached a pbix file for reference.
Quick help will be appreciated.
Thanks,
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.
@Syndicate_Admin I couldn't find any attachment. It would be great if there is a DAX formula to resolve this. Is there any possibility to get a calculated column which displays the decimal hours in hh:mm format.
Thanks again
#1
mmbr1606
9
Super User 2025 Season 1
#2
stampcoin
7
#3
SD-13050734-0
6
Share
Report
All responses (
Answers (
