We need an excel template or Word macro that can calculate using timecode. We are building Post Production scripts that list in a word doc the IN timecode and the OUT timecode in separate columns, and we are required to enter the DURATION of the shot in a separate column. As you can imagine, manually entering this information into a timecode calculator and then typing the resulting duration back into the Word doc is too time consuming. We also have to do offsets, where, for example, if there is an increase of length in ad breaks between an International and Local version of a TV program, we need to add, say 37 seconds to the timecodes after the first ad break, and so on.
Perhaps easiest is a page in excel that we can cut and paste the timecode IN column into and then the timecode OUT column from our Word post production script, the excel page does the duration calculation and then we can cut and paste the duration back into the Word doc. It would have to be the whole timecode (eg 10:00:10:01) including frames in the one cell, or it will take too long to enter the information. In the case of the offset, we would just duplicate 'add 37 seconds' and cut and paste the new timecodes into our Word doc. But if there is a way working directly into Word eg using a calculation macro, AND YOU CAN EXPLAIN to us how to use it clearly (as we are not geeks!) that would be great too.
We are using PAL 25 frames for Australian television. Whatever supplied would have to work the same on pc and Mac. We need quotes on this job asap because there is a tight deadline to finish these post production scripts. Please only quote if you have an understanding of PAL timecode. Thank you.
6 freelancers are bidding on average $128 for this job
Hello, We have excellent team of programmers and designers to work on your project efficiently and complete job in time. We have read your deepest requirement at our best and will surely give better results. thanks