Convert minutes to hours and add them up

[Syndicate_Admin]

Hello, I have a problem, I have a Power Bi colunmna that adds the minutes and hours of a sharepoint list, that column has the total minutes, but I need to convert these minutes to hours and minutes (HH:MM:SS) and that allows me to see the total of the sum of those values:

Here's the column:

Here I tried to do the calculation by means of a measure, but it adds all the values and does not return the calculation correctly:

For example, in the power bi it tells me that it is 13hr and 20min:

But in the export of the list when doing the calculation it gives me 22hrs:

[Syndicate_Admin · Accepted solution]

I was able to solve it in the following way:

1. I took as a reference the same process I was doing in excel, adding the minutes and dividing by 60 to give me the value of the hours and minutes.

2. Create a measure to add up all the values:

3. Then under another measure I created a variable that contains the measure I initially created, then I divided that variable into 60 (sum of minutes / 60) and then I used MOD to bring the remainder of the initial division, at the end I put the return to bring me the information:

4. Finally, the power bi brings me the info in the right way.