topic Calculating Total Hours when summing times in QlikView

Calculating Total Hours when summing times

Tue, 17 Dec 2013 03:39:15 GMT

Hi there,

I am trying to calculate total hours and my results keep rolling over when reaching 24 hours. How do I format the field so that when the total is over 24 hours this will show correctly.

The expression I am using is:

Interval (Sum(TS_TimeActivityFinish-TS_TimeActivityStart),'hh:mm')

Many thanks,

Pip

Re: Calculating Total Hours when summing times

tresB — Tue, 17 Dec 2013 04:37:41 GMT

If you want number of days when it is over 24 then try like:
Interval (Sum(TS_TimeActivityFinish-TS_TimeActivityStart),'dd:hh:mm')

Re: Calculating Total Hours when summing times

Tue, 17 Dec 2013 04:40:19 GMT

Hi,

thanks this has not worked. I added the timestamp# function prior to this and is has worked.

Thankyou for your assistance.

Timestamp#(Interval (Sum(TS_TimeActivityFinish-TS_TimeActivityStart),'hh:mm'))

Cheers,

Pip