Hello. I came on ee last year with this question and had a part work around which was good but has a few glitches. I'm attaching a small version of the file I'm working on.
I need help with the following:
Checking the formulas in the green columns. These are calculations of the Time In and Time Out columns to show the duration in FF and SS of each shotEx-Exchange-Formula-Help.xls
. I think they are correct but I'd love someone to check these to ensure they are ok. I had a fair few errors last time I had to go in and manually adjust which takes hours.
I'd love it if someone is able to expand this formula to 300 lines depth. I did have a few lines sent last time but when I transfered into another file with my text and timecodes things got tricky and messy. I suspect it would be easier and less of an error magnet if I can transfer text into a file with the calculations already on it rather than the other way around!
It was suggested I have a frame value check column to pick up any errors. There were a lot of errors last time I had to go in and manually do so I'm wondering if anyone can check that columns formula too. Essentially I need an airtight (if possible!) way to calculate Time Code IN and Time Code out to get the duration in seconds and frames of each line/shot length. I have six documents each about 300 lines long hence hoping someone can send me a document of this lenth with the formulas copied down it so I can just cut and paste in my text.
I am working with 25 frames per second. hh:mm:ff:ss
If the return document is too big it could go into my hightail link which I could send...
Thank in advance, this is headache making! I'm certainly no expert.