sum of hours

[ilanbaruch]

hi all

trying to sum rows of hours (hh:mm format), in monthly level, i.e:

20190101 08:40

20190102 07:32

20190103 11:02

expected result : 27:14-> 27 hours and 14 minutes

any ideas ?

advanced thanks

[sunny_talwar · Accepted solution]

Try this

Interval(Sum(Frac(FieldName)), 'hh:mm')

[ilanbaruch]

Thank you Sunny
my final :
Interval(Sum(DailyHours), 'hh:mm:ss')