Forum Discussion

Ignacio06's avatar
Ignacio06
New Member
2 years ago
Solved

displaying accumulated hours

Hello, I have a simple problem with the display of accumulated hours data. For example, when a user has 26 accumulated hours of work (in sum of several days), Power bi gives me (with the time format "hh:mm") 02:00 (24h+2) when I need to show 26:00.
Any idea?. Thank you very much from Madrid

Need Help
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    Hi Ignacio06 

     

    You can refer to my anser here Re: Need Help - Converting Seconds to HH:MM:SS and... - Microsoft Fabric Community

     

    If you want a measure the culamative value and convert to HH:MM then try this. Presumimg you have a value in your table as Hours?

     

    Hours Total = SUM('Table'[Hours])

     


    Then this

     

    HH:MM = 
VAR _Seconds = [Hours Total] * 3600
VAR _Min = INT(MOD(_Seconds, 3600) / 60)
VAR _Hours = FORMAT([Hours Total], "00") 
VAR _Minutes = FORMAT(_Min, "00")
RETURN

_Hours & ":" & _Minutes

     

     

    Thanks

    Joe

     

    If you found my answer helpful and it solved your issue, please accept as solution

     

     

1 Reply

  • Joe_Barry's avatar
    Joe_Barry
    Icon for Solution Sage rankSolution Sage
    2 years ago

    Hi Ignacio06 

     

    You can refer to my anser here Re: Need Help - Converting Seconds to HH:MM:SS and... - Microsoft Fabric Community

     

    If you want a measure the culamative value and convert to HH:MM then try this. Presumimg you have a value in your table as Hours?

     

    Hours Total = SUM('Table'[Hours])

     


    Then this

     

    HH:MM = 
VAR _Seconds = [Hours Total] * 3600
VAR _Min = INT(MOD(_Seconds, 3600) / 60)
VAR _Hours = FORMAT([Hours Total], "00") 
VAR _Minutes = FORMAT(_Min, "00")
RETURN

_Hours & ":" & _Minutes

     

     

    Thanks

    Joe

     

    If you found my answer helpful and it solved your issue, please accept as solution