Help with sum of time

[#1]

Hello all,

yet again I turn to this lovely community for answers and help.

I have a problem with summation of time, as you can see in attached file.

The total for Total Time per location is not valid, as you can see it should be in days not in hours.

Is that a problem? Is there a limit in how much data can be stored?

Can you help me to get it right, and to get right percentages?

Thanks in advance

[MarcoWedel · Accepted solution]

Hi,

change your expression "Total Time per location" into:

=Interval(sum(TaskExecutionHistoryItem.Duration))

and set number format to "expression default"

hope this helps

regards

Marco

[MarcoWedel]

or better use

=Interval(sum(TaskExecutionHistoryItem.Duration), 'DD hh:mm:ss')

to also show the day-part of those intervals.

hope this helps

regards

Marco