Monday, May 19, 2014

yogi_Compute Row By Row Number Of Frames From Timepoint1 To Timepoint2 Using Specified Frame Rate

                                         Google Spreadsheet   Post  #1641
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May-19-2014
post by samuel.mehr: (!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.