Google Spreadsheet Post #1641
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. May-19-2014
post by samuel.mehr: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/dFe8ezflA0A)
Support for HMSF timecode parsing?
I'd love to be able to enter timecode in HMSF format (e.g., 01:35:55:12) and have Sheets read it as a raw count of frames (e.g., 172662 assuming 30fps). Then I could use this format in some simple arithmetic for calculating duration of video clips. Anybody have the chops (and incentive) to put that together...? I'd give you at least a high five in return.
---
I can't seem to get the cell formatting to work properly. I want to be able to enter two timecodes and compute the difference in # of frames between them. I tried formatting as a custom duration but that didn't work, partially because it won't allow me to subtract between two timepoints, and also because the last unit shouldn't be milliseconds; it should be frames, which are rarely 1/1000 of a sec.
It would be totally straightforward to do this separating out the timecode into 4 cells and computing a total by arithmetic, but I'd like to do it more elegantly -- best case scenario would be to enter the actual timecode at 30fps (e.g., 01:23:45:12) and have it convert automatically to a frame count (150762 for this example) so that I can grab framecounts directly from a cell to use in analyses.
simple example here... https://docs.google.com/
-------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment