| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tape recording time code?
=LEFT(A1,2)/24+MID(A1,4,2)/(1440)+MID(A1,7,2)/(86400)+RIGHT(A1,2)/(2073600)
watchout for any extra wrap characters -- Gary''s Student - gsnu200746 "Gervin Callo" wrote: COULD YOU PLEASE check the formula u gived because its not working when i entered there is a msg that the formula you entered contains an error.. or could u pls send me the sample as ms excel format... i need Film (24 frames per second) .. ty |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Created date in "General" tape and "Statistics" tape | Excel Discussion (Misc queries) | |||
| Recording elapsed time | New Users to Excel | |||
| recording more than 2 changing values in Excel at a time??? | Excel Worksheet Functions | |||
| recording negative time | Excel Discussion (Misc queries) | |||
| Recording time in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
