I've used this in Excel & Google Docs successfully, but it's returning "Err:508" in Calc 4.14
Code: Select all
=TEXT(LEFT(B2,8)-LEFT(A2,8)-(RIGHT(A2,2)>RIGHT(B2,2))/86400,"m:ss")&TEXT(MOD(RIGHT(B2,2)-RIGHT(A2,2),24),"\:00")
A2: 01:22:32:14
B2: 01:22:35:10
and the formula returns: 0:02:20 as the duration, this is for timecode calculated at 24 frames per second.
Unfortunately I'm nearly illiterate with formulas like this, and I can't figure out how to make it work in Calc.
Thanks in advance!