Hello! 

I’ve been trying out different formulas but I can’t get it to work. So as per below data, column B is a set of duration timecodes. I want to calculate the duration of the timecodes that only fall between C to T (coloured). And the formula won’t repeat itself on the same set of C to T. Does anyone know how? thank you!

​Hello! I’ve been trying out different formulas but I can’t get it to work. So as per below data, column B is a set of duration timecodes. I want to calculate the duration of the timecodes that only fall between C to T (coloured). And the formula won’t repeat itself on the same set of C to T. Does anyone know how? thank you!  Read More

​