Timecode calculator excel from cut duration

broken image
broken image

Like, on my screenshot below, the audacity detected 28.195 would be between frames, so I use 28.183 that would be exact 00:28.11 (28sec 11 frames). Your explanation did help me a lot, I just had to use formulas to convert “absolute” seconds into “relative” (difference between ending of the last beat-shot to the start of the new one) seconds, also keeping in mind that i have to convert 1000ms into 60frames/sec, so I calculate “the exact second” from the left, to fit the exact moment, when shot should’ve started.

broken image
broken image

Actually, I took your approach and figured out the current format of mlt file, so I created google spreadsheets file, that converts audacity file (3 columns) into xml-like format to paste into mlt file via notepad =D

broken image