You can access the sheet here, which contains some examples as well as basic instructions on how to use the document. if you add non-even frame rate support), I encourage you to share them with Henrik so that the whole post community can benefit. Once you make a copy of the document you can modify it to your heart’s content – although if you do make any useful changes to the code (i.e. For assistant editors who have to spend a lot of time crunching timecode within a spreadsheet – this could save you a HUGE amount of time.Īs Google Sheets is cloud-based, this is nothing something you can just download and install – you need to have a Google Account, and then “Make A Copy” of Henrik’s document, storing your own version in your personal Google Drive account. If you’re in 25fps land, this is an incredibly useful tool that you can make use of today. 23.976fps) – but apart from that, it’s incredibly simple and powerful, with support for timecode addition, subtraction, division, multiplication, percentages as well as timecode conversion (i.e. It’s early days, and the code does not currently support obscure non-even frame rates (i.e. Converts a date in the form of text to a serial number. This function is useful in formulas where you need to calculate an age. Calculates the number of days, months, or years between two dates. What’s REALLY exciting though, is that the incredibly clever Stockholm-based Henrik Cednert has put together an awesome script (inspired by Nuke/Hiero Timecode Calculator) that allows you to calculate timecode within a Google Sheets document. Returns the serial number of a particular date. The timecodes it processes must have the same frame rate per second (fps). It’s also completely compatible with Excel and Numbers – and it’s free. TC Duration is an online tool designed to calculate the duration between two timecodes. It’s web-based, but there are also iOS and Android versions that all play nicely together. As part of that suite, Google Sheets is basically Google’s version of Excel/Numbers. Google Docs is a free, web-based office suite offered by Google within its Google Drive service – allowing you to create and share your work online and access your documents from anywhere. Hopefully one day someone puts together some incredibly clever AppleScripts that add this functionality, however in the meantime… Unfortunately however, getting timecode to work successfully and reliably in Numbers has never been something I’ve been able to fully accomplish. Even though it’s now around 3 years old, it still gets a constant amount of views each week.Īlthough the Excel article is still relevant and useful – personally, I don’t actually use Microsoft Excel very often any more, much preferring Apple’s Numbers (which comes free with every Mac and iPad/iPhone for that matter). One of the most popular blog posts we’ve ever done has been on Calculating Timecode in Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |