Alright. I am trying to get the total number of seconds an associate spends on a task (later this will be converted to hours, mins & secs). I have the data split by a blank row in between each associate. I am trying to use the multi row tool to say: If the cumulative seconds are null then subtract the last cumulative seconds from the one before for however many rows are above.
In the screen shot below I only have it subtracting two rows, 39348-39208. Does anyone know how to make the subtraction part of the formula dynamic, to accommodate however many rows are above?
Thanks
Cassie
