Multi Row Subtraction - Dynamic Numbers to subtract

[Cassie_Shaw]

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

[binu_acs]

@Cassie_Shaw One way of doing this

[Cassie_Shaw]

@binu_acs Hi! I am looking to subtract all values in the Cumm Sec column for each associate. I didnt know if there was a dynamic way to say subtract all values under "associate" A for example. 

[binu_acs]

@Cassie_Shaw @Can you provide some sample data and expected results?

[Cassie_Shaw]

@binu_acs Sure. So in this example I would want the 140 to be 39208-32339 = 6869 then 39348 - 39208= 140 then 6869+140= 7009 this equal the total time worked that day. But the number of cases differs by associate, its not always 3. 

As I type this, I am starting to think I need another approach. :(

[binu_acs]

@Cassie_Shaw are you expecting the output like below sample data?

[binu_acs · Accepted solution]

@Cassie_Shaw Let me know if the attached workflow works for you or not.

[Cassie_Shaw]

@binu_acs THANK YOU! Yes, this formula helped me get my end result. I cant thank you enough. I literally worked on this ALL DAY!