In the film music business we synchronize music to film frames by a standard known as SMPTE timecode. A frame of film is labeled by hr:min:sec:frames.
For instance a picture starting a 4 hours 8 sec would have SMPTE timecode 04:00:08:00. If we are working at 24 frames per second the difference between 01:01:10:10 and 01:01:09:20 would be 14 frames. In other words 01:01:10:10=01:01:09:34 minus 01:01:09:20=00:00:00:14.

How can I set up a cell so that if I type in 01223304, 01:22:33:04 would appear denoting SMPTE timecode. Then I would like to subtract one cell from the other to get the correct difference in min:sec:frame.

I would also like to be able to switch between 30 frames/second and 24 frames/sec formats. For instance, At 24 fps 01:01:10:10 minus 01:01:09:20 =14 frames. At 30 fps 01:01:10:10 minus 01:01:09:20 =20 frames.

I am an excel novice and don't even know where to begin.