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.