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...
You might be able to use this DAX pattern, based on seconds rather than hours: https://community.powerbi.com/t5/Community-Blog/Aggregating-Duration-Time/ba-p/22486
Great question! In Power BI, you can handle this by creating a custom column using DAX. For example, if your column is [DecimalHours], you can use:
This will convert 3.5 into 03:30. If you need to handle values over 24 hours, consider avoiding the TIME () function and just stick to string formatting like this. Power Query also works well for such transformations. Hope this helps!