Forum Discussion

Pooja-B's avatar
Pooja-B
Regular Visitor
3 years ago
Solved

Convert minutes into hours

Hi,    In Power BI I have a column name has Worked minutes as 110 minutes.  This 110 minutes I have to convert into hours as "1:50"  How to convert the 110 as 1:50 Thanks in advance, Pooja-B.
Need Help
  • Arul's avatar
    Arul
    3 years ago

    Pooja-B ,

    Are you using the same formula? I got the correct output.

    Please see the below,

    Thanks,

    Arul

Pooja-B's avatar
Pooja-B
Regular Visitor
3 years ago

Hi Arul ,
 I need that hours coulumn datatype as  decimal numbers because I need to add the sum of worked hours.
I already have workedMinutes column have data as 110 "Whole number datatype".
The hours column I need 1:50 as decimal number datatype.

In above mentioned thread they were in text datatype.

Thanks,
Pooja-B

 

Arul's avatar
Arul
Icon for Super User rankSuper User
3 years ago

Pooja-B ,

If you requirement is to calculate the sum of hours, Can you try the below formula in measure?

Minutes to Hours = 
VAR _hours = ROUNDDOWN(DIVIDE(SUM('Table'[Minutes]),60),0)
VAR _minutes = MOD(SUM('Table'[Minutes]),60)
VAR _result = FORMAT(_hours,"#00")&":"&FORMAT(_minutes,"#00")
RETURN _result

Thanks,

Arul;

  • Pooja-B's avatar
    Pooja-B
    Regular Visitor
    3 years ago

    Hi Arul ,
      Thank you so much for your response. Its working fine.
     But I need some exact answer sir.

    I have 2 times here, 
                    Minutes    Hours
                      220            3:40
                      225            3:45
    Total Hours worked = 7:25
    The above your given code, I tried in "calculated measure" its working in table visual but not working in the stacked column chart visual


    Thanks,
    Pooja-B

    • Arul's avatar
      Arul
      Icon for Super User rankSuper User
      3 years ago

      Pooja-B ,

      this is not possible but you can add that measure in tooltip lik the below,

      Thanks,

      Arul

       

      • Pooja-B's avatar
        Pooja-B
        Regular Visitor
        3 years ago

        Arul ,

        Here I need the total as 7:25 here showing 8:00

         

        I added Tooltip as "Minutes to Hours" but its blank here

        Thanks,
        Pooja-B.