How do I add the following 00:30:20;00+01:22:25;00

B

Bridges TV

These are the times for my programming library that I need to add. This is
hh:mm:ss;frame

please help
 
F

Fred Smith

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?
 
Top