Post #314725

Author: Moth3r
Parent topic: Converting framenumber to timecode
Link to post in topic: https://originaltrilogy.com/post/id/314725/action/topic#314725
Date created: 27-Mar-2008, 12:23 PM

Here's how I did it. Not the most elegant spreadsheet, but it worked...

http://img405.imageshack.us/img405/8915/excelvw3.th.png

(You won't need the "Adjusted Frame Number" column.)

Then copy columns K to O, from row 2 onwards to the last chapter, and "paste values" into another worksheet. Save this worksheet as a csv file, then you can import straight into CCE.