Forum Discussion

sgross's avatar
sgross
Helper I
9 years ago

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...
MarcelBeug's avatar
MarcelBeug
Community Champion
8 years ago

An alternative would be:

 

= List.Sum(
    List.Transform(
        List.Zip({
            Text.Split(
                [Tiempo transcurrido],
                ":"),
            {1,60,3600}}),
        each Number.From(_{0})/_{1})
    )
jbolivar's avatar
jbolivar
Frequent Visitor
8 years ago
MarcelBeug wrote:

An alternative would be:

 

= List.Sum(
    List.Transform(
        List.Zip({
            Text.Split(
                [Tiempo transcurrido],
                ":"),
            {1,60,3600}}),
        each Number.From(_{0})/_{1})
    )

Excellent..it worked too 

 

Thank you