Convert Decimal Time to Days, Hours & Minutes in Power BI

[IvanCortinas_ES]

Thanks for diving into Power BI Mynda. There is the present and the future.

[chrism]

Thanks Mynda, I need to spend some more time in PowerBI!

[darrylmorgan]

Hi Mynda!Neat Dax Measure To Convert Decimal Time With Great Explanation From Phil...Thank You Both :) :)

[MEWORLDTV]

I like to thank you personality for the awesome knowledge you are imparting to the world

[mattschoular]

Hi Mynda, the overview is helpful and the option to download the file is also useful. It may have also been helpful to walk through the code that was "written earlier and pasted in". That is the heart of the solution.

Regardless, thank you for the video, it is good information...

[saojoaomeriti]

Good afternoon.

How can I calculate work hour on Power BI?

For example: date and time start "09/15/2021 07:00 a.m" and date and time process finished "10/15/2021 08:30 a.m". The duration (result) of this process between this date and time is = 11:30 hours (without count Full 24 hours, just count work time available).

The period of job starts at 7:00 a.m and the end is 5:00 p.m.

[anillpatel]

Excellent video presentation. Very well explained.
Thank you.

[Michael_Burris]

This video was awesome - helped me to solve a roadblock and I learned a lot. Thanks!

[wayneedmondson]

Thanks Mynda and Phil. Interesting solution. Thanks for sharing :)) Thumbs up!!

[sarva]

Thanks for sharing...can you please tell how can use this formatted Time field in the Y axiss of Line Chart

[Mahmoudalgindy]

Thanks a lot Mynda.
I just thinking about keep the decimal as it is and use Dynamic Formatting string, it works for me but not all the rows are correct.
I hope you do short tutorial about that, thank you

[rams]

After doing this how to apply sum on this measure to see time spent on each activity, or a each day

[maijai]

Thanks a ton for the explanation, is there a way to make it work when arevaging by a group, in your example for instance by east, south, west and /or north?

[ladhkay]

Ty for this!!! I load duration value in Power BI and I get decimals and I'm wondering like what does it represent since it doesnt have any units?? Thanks for clearing it up!

[jinggao]

Thank you so much for sharing Mynda! May I ask how to convert days, hours & minutes to decimal time in Power BI? I got a bunch of data which just show d, h, m, s - "1d, 6h, 30m, 38s" for example. Have no idea how to deal with them... Would be very appreciated if you can make a video of that. Thanks in advance!!

[moshearama]

I can't get values ​​greater than 24 hours i get only what is less..
Is there a possibility to fix it?

[DiamondRock]

Thanks for your effort We appreciate :)

[gourabdas]

Hello Mynda, I have a doubt where can I find the Excel time format 37:30:55 in power BI which is above 24 hr. I need "hh:mm:ss" format in power BI which is should be in above 24 hr format.

[zakhelembhele]

You Guys are just amazing! Thank you so much!

[wexwexexort]

Good but in the it's text, how can I aggregate over those? For example I need the total delivery time for each week. I did the aggregation on the decimal part but I want to display the result in a formatted way as yours. Any help?