Sum time duration

[#1]

Hi everyone, 

I am new in qlikview and I have one problem with adding different durations times in this format 'YYYY/MM/DD HH:MM:SS.fff'. In this field I have years, months and days with 0 (i.e 0/0/0 03:01:00)  and I do believe this is the issue. Can you help me solved it?

Thanks in advance..

Best regards

José João Grave

[swuehl]

Just use the time part:

=sum(interval#( right( YourField, 8), 'hh:mm:ss'))

[MarcoWedel]

Hi,

one solution could be also:

=Interval(Sum(SubField(duration_txt,' ',-1)))

hope this helps

regards

Marco