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: