Calculating Total Hours when summing times

[#1]

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

[tresesco]

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

[#3]

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