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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

please help
 
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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top