How do I add the following 00:30:20;00+01:22:25;00
These are the times for my programming library that I need to add. This is
hh:mm:ss;frame please help |
How do I add the following 00:30:20;00+01:22:25;00
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? -- Regards, Fred "Bridges TV" <Bridges wrote in message ... These are the times for my programming library that I need to add. This is hh:mm:ss;frame please help |
All times are GMT +1. The time now is 10:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com