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...
Thank you for this, this worked really well.
Is there a way to stop it being a "text" format though as i would like to SUM the output of this.
You can also do this in the Query editor:
= Time.Hour([Time])+(Time.Minute([Time)/60)+(Time.Minute([Time])/3600)
No problems with text format.