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 here who has the experience to do such a thing?
4 Replies
Sort By
- NikolinoDEGold 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)
Sorry, but I found no one example of working with frames in file you submitted.
- NikolinoDEGold Contributorups ... didn't see the frame ... all good.
thanks