![]() ![]() 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. Consider it a template, to be expanded and modified to your needs. Accompanying this document is an Excel spreadsheet with the formulas to accomplish this. If you’re in 25fps land, this is an incredibly useful tool that you can make use of today. Now you can log shots and determine duration without having to run back and forth to a timecode calculator. 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. 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. It’s also completely compatible with Excel and Numbers – and it’s free. 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). Excel will recognize this as a time value instead of text. One of the most popular blog posts we’ve ever done has been on Calculating Timecode in Excel. You can add these normally if you enter the time as 04:11:12.12 instead of 04:11:12:12. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |