-
Timecode calculator/script word-count convertor
I am trying to find a Mac-friendly timecode calculator that will take the word count from a written film script and turn it into hours:minutes:seconds. I have a timecode calculator that adds timecodes, and the Tiger’s Dashboard has a time converter widget. It’s usually 3 words to a second but I don’t want to have to keep fiddling about with the Math and two applications. Any FCP-ers ever come across a solution? Maybe someone should write a widget (if only I had the time or knowhow…)
-
1 Reply
-
If you have Excel, you can do it with this formula:
(wordcount / 3) / (number of seconds in a day — 60 seconds * 60 minutes * 24 hours)
In Excel less than 24 hours is formatted as the decimal portion of 1 day (“.” something, with .5 being half a day, or 12 hours).
Then format this cell as hh:mm:ss.
So if your word count is in cell A1, then another cell could have this formula: =(A1/3)/(60*60*24)
Then format this formula cell as hh:mm:ss, and you have your timecode.
Reply to this Discussion! Login or Sign Up