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
Solved! Go to Solution.
@binuacs 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.
@Cassie_Shaw @Can you provide some sample data and expected results?
@binuacs 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. :(
@binuacs THANK YOU! Yes, this formula helped me get my end result. I cant thank you enough. I literally worked on this ALL DAY!