Top up a column with another column value

Moughabat

I have two columns in my sheet, one that is ACTUAL HOURS, and one that is WORKED HOURS.

Every time users enter worked hours, the workflow automation takes those hours into that user timesheet, and then clear the WORKED HOURS column so that user can re-enter other hours at any later point of time… at the end of the task (when we complete it), I want to know all the hours spent on this task, and that would be the comulative WORKED HOURS… I would like Actual Hours to be updated on the go whenever Worked Hours are added.

Ex:

Day 1-

Actual Hours = 0

Worked Hours = 5

*Missing* —> Actual Hours = 0+Worked Hours = 5

workflow clears Worked Hours —> Worked Hours = 0

Day 2-

Actual Hours = 5

Worked Hours = 3

*Missing* —> Actual Hours = 5+Worked Hours = 8

workflow clears Worked Hours —> Worked Hours = 0

SueinSpain

Only thing I can think of is to add another column for cumulative worked hours and add intothat too.

e.g. day 1 cummlative worked hours = 5

day 2 cumulative = 5 + 3 = 8 etc.

before the workflow clears the worked hours field