Forum Discussion
mortenhjort
Jun 05, 2021Copper Contributor
Convert time and frames to seconds
I have several cells with a timecode like "tt:mm:ss:ff" (ff being frames of which there is 24 of per second). I have yet to figure out a way to convert this into whole seconds with a formula. Anyone ...
NikolinoDE
Jun 06, 2021Platinum Contributor
With the permission of everyone, here are a few more examples about time,
in addition to the correct solution from Mr. Baklan.
I wish you continued success with Excel
Nikolino
I know I don't know anything (Socrates)
- SergeiBaklanJun 06, 2021Diamond Contributor
Sorry, but I found no one example of working with frames in file you submitted.
- NikolinoDEJun 07, 2021Platinum Contributorups ... didn't see the frame ... all good.
thanks