Question

Calculate the total time(datetime type)

0

Hi Team, I want to calculate the total time of multiple tasks inside a Procedure and store them in another entity. So that I can show the total of columns on the parent page. See the attached screenshot. Tasklist page Parent Page Please help!

asked 2022-06-01

Vichitra Choudhary

3 answers

Jurre Tanja · Answer 1 · 2022-06-02

What if you store the StartTime and EndTime of the Procedure in the different entity as well, if you then use the between date functions to display the total time occurred in a string.

Roy Noordhuizen · Answer 2 · 2022-06-02

What if you create a microflow that will take the sum of the list items and sums up the allotted time and store that in a new attribute?

Roy Noordhuizen · Answer 3 · 2022-06-02

Did you use the Secondsbetween or something similar? function to calculate the allotted time? This will give you a decimal value if i'm correct. You can use this value to convert this to the amount of hours/minutes to show. It seems that the date time attribute is not really suitable to show a sum of hours (in my opinion)