Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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