So I basically want it to where when anyone submits a google form connected to the google sheet, it automatically updates their, let's say duration (time), and adds it on to the duration currently set on the google sheet.
If that didn't clear it up then let's say I have a roster (a list of people) and each one of them has their own duration of how much they've worked (default is 0:00) and they can go on a google form to fill out their name, ID, and the duration of their hours, and as soon as it's submitted it gets updated to the google sheet and their time adds on to their current duration, not replacing it instead, but this can only happen if they filled in a name and ID already pre-set on the roster.
Any help with making this happen?