displaying accumulated hours

[Ignacio06]

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

[Joe_Barry · Accepted solution]

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