How to Convert Minutes in Hours

[Alihan_02]

aftermy formula to change Sum(durationminutes) to my new field: Zeit Stunde:Minutenas you can see it did not change like i wanted, the original field is on the right and on the left the new one. the results in my new element are my missing. Can someone tell me what i did wrong?

[Fabiano_Martino_Intelco · Accepted solution]

Hi @Alihan_02 

since in the table you are using ad aggregation function, Sum(durationMinutes), I suggest you also use it in the formula.

Interval(Sum(durationMinutes)/24/60, 'hh:mm')

Regards

Fabiano

[Alihan_02 · Accepted solution]

Danke