I am working with Excel file (see example attached) where I need to get different time points in a SMPTE Time Code. In the columns G, I, and L we have time in seconds. I need to come up with the formula that will convert seconds into the time code. This time code is supposed to have a format HH:MM:SS:FF where FF stands for frames. So all decimal seconds should be converted into frames number, taking in account that we have 23.97 frames per second.
Also I have to count the duration of video clip by subtracting the value in column H from the value in column J. The duration should also have the format HH:MM:SS:FF.
Thanks in advance for the help,