Convert Duration (d.hh:mm:ss & hh:mm:ss) to Decimals (in hours)

[e0318476]

Hi all, 

I have 2 rows that i will need to convert them to decimals in hours.

Please help, thank you!

[e0318476]

Hi @Vera_33 & @mahoneypat :

This is the outcome I want to get (this is done in excel). However, based on the solutions provided by both, it does not re-solve my issue. Please advise!

[ronrsnfld]

What is the issue. I suggest you did not properly implement the solution provided by @Vera_33   It works fine here although, in PQ, it displays more precision that you show in your desired result (which you can easily handle by rounding, or by formatting in Excel)

Please show the exact code you are using.

[e0318476]

Apologies for my mistake. Thank you for pointing out. @ronrsnfld 

[mahoneypat]

Please also see this article for how to best handle DateTime columns and duration calculations in Power BI.

Calculate and Format Durations in DAX – Hoosier BI

Pat

[Vera_33 · Accepted solution]

Hi @e0318476 

You need total hours, right?

 Duration.TotalHours([yourEndDateTime]-[yourStartDateTime])