Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
These are the times for my programming library that I need to add. This is
hh:mm:ss;frame please help |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|