G Guest Nov 28, 2006 #1 These are the times for my programming library that I need to add. This is hh:mm:ss;frame please help
These are the times for my programming library that I need to add. This is hh:mm:ss;frame please help
F Fred Smith Nov 29, 2006 #2 First you need to tell us how you want the answer to look, and what range of data you have. If the frames are always zero, you can use: =substitute(a1,";",".")+substitute(b1,";",".") and custom format as h:mm:ss";00" If frames can be more than zero, tell us how you want them carried over to seconds. Thirty frames per second?
First you need to tell us how you want the answer to look, and what range of data you have. If the frames are always zero, you can use: =substitute(a1,";",".")+substitute(b1,";",".") and custom format as h:mm:ss";00" If frames can be more than zero, tell us how you want them carried over to seconds. Thirty frames per second?