Convert time and frames to seconds

Question

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?&nbsp;

sergeibaklan · Answer

mortenhjort&nbsp;
That could be like

Formula is
=TIMEVALUE(LEFT(A1,8))+RIGHT(A1,2)/24/60/60/24

nikolinode · Answer

mortenhjort&nbsp;With the permission of everyone, here are a few more examples about time, in addition to the correct solution from Mr. Baklan.&nbsp;I wish you continued success with Excel &nbsp;NikolinoI know I don't know anything (Socrates)

sergeibaklan · Answer

NikolinoDE&nbsp;
Sorry, but I found no one example of working with frames in file you submitted.

nikolinode · Answer

ups ... didn't see the frame ... all good.thanks

Forum Discussion

Convert time and frames to seconds

4 Replies

Resources