Sum of Hours

[Qlikuser225]

Hi All,

I have data like

Hours

128:12

147:00

0:54

128:12

147:00

0:54

115:12

Can anyone please help me to calculate sum(Hours) from above.

I have used - Interval(Sum(Hours), 'hh:mm') and its not working.

Thanks

[MayilVahanan]

Hi @Qlikuser225 

Try like below

Interval(sum(Hours), 'hh:mm')

[tresesco · Accepted solution]

Your expression should have worked. If not, you can assume that your default time formats are not helping qlik read the timestamp as time but string. Hence, you could parse the string and then try to to sum it up, like:

=Interval(Sum(Timestamp#(Hours, 'h:mm')), 'h:mm')