I found this extremely helpful excel formula (link below) which can calculate the duration of a clip in timecode.

http://www.excelforum.com/excel-gene...l-formula.html

=TEXT(LEFT(G6,8)-LEFT(F6,8)-(RIGHT(G6,2)>RIGHT(G6,2))/86400,"s")&TEXT(MOD(RIGHT(F6,2)-RIGHT(G6,2),29.97),"\:00")

Would it be possible to take that formula and modify it to add the two values I have received? Let's say that I used that formula to get the value in row 6, and then copied it to apply in row 7, would it be possible to change that formula to add the sum of the duration values in rows 6 and 7? So H6 + H7 but in a 29.97 world?

Thanks in advance to any help!