If the task is to put in a number of hours manually and get a total sum of them, then I can suggest the following.
- Create two new columns for a "Ticket" list: "LastSpentTime" and "TotalSpentTime". Choose a number type of data. The first column is required to contain information, the second one has a default value set to
0. I set the number of decimal places to unify data presentation.
- Using Forms Designer, edit ticket forms.
First, open "Edit Form" and add a "LastSpentTime" field to it. Set the width of the table cell to 100, specify a title, and set control width to 200. Orientation is vertical. Save the form.
Second, open "Display Form" and add a "TotalSpentTime to it. Control properties to edit are the same, bur orientation is horizontal.
- Create a flow on Microsoft Flow. When an item is created or modified in the "Tickets" list, the flow is started. Pass the required parameters from a trigger action. Update only "LastSpentTime" to
null and add the current "TotalSpentTime" to "LastSpentTime" and assign it to "TotalSpentTime". Use the following expression:
Now it is possible to see the total spent time which was entered manually:
The flow is infinite, because the flow starts on the item modification and modifies the one by itself. To avoid the infinite reiteration add a condition after the trigger and put the further action in "Yes" block. In the condition, the "LastSpentTime" value should be not equal to
null. So if the flow has changed the field value to
null or for some reason it's empty, the item will not be updated.