Forum Discussion
Converting Decimal Hours to Time Format
Is there a nice easy way to convert decimal hours into hours/minutes in Power BI? A function that essentially does this? For example, turning 3.5 hours into 3 hours and 30 minutes? I've found...
If you want to exceed 24 hours, then you need Duration format, like:
Duration.From([DecimalTime]/24)
Yes, this saved me. I can't believe it was so hard to find this. So many convoluted solutions lol