| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Time Code in Cell format ?
Hi there,
Can anyone give me the function to enter Time Code values in Excel cells (Hour: Minutes: Seconds: Frames (24, 25, 29,97, 30) , as the only time values available are Hour: Minutes: Seconds: 10th of seconds ?? Thank you very much. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Code in Cell format ?
Define Frame
-- Gary's Student " wrote: Hi there, Can anyone give me the function to enter Time Code values in Excel cells (Hour: Minutes: Seconds: Frames (24, 25, 29,97, 30) , as the only time values available are Hour: Minutes: Seconds: 10th of seconds ?? Thank you very much. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Code in Cell format ?
See if this link throws up any help http://tinyurl.com/y44645
-- --- HTH Bob (change the xxxx to gmail if mailing direct) wrote in message ups.com... Hi there, Can anyone give me the function to enter Time Code values in Excel cells (Hour: Minutes: Seconds: Frames (24, 25, 29,97, 30) , as the only time values available are Hour: Minutes: Seconds: 10th of seconds ?? Thank you very much. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Time Code in Cell format ?
.... or a bit wider http://tinyurl.com/yyyok9
-- --- HTH Bob (change the xxxx to gmail if mailing direct) wrote in message ups.com... Hi there, Can anyone give me the function to enter Time Code values in Excel cells (Hour: Minutes: Seconds: Frames (24, 25, 29,97, 30) , as the only time values available are Hour: Minutes: Seconds: 10th of seconds ?? Thank you very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help (Uppercase multiple ranges?) | Excel Discussion (Misc queries) | |||
| How do I format a cell for time (ex. 02:17 without AM or PM)? | Excel Discussion (Misc queries) | |||
| Cell contents with custom time format rounded after double-click | Excel Discussion (Misc queries) | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
| can't format cell - have tried unlocking and unprotecting | Excel Discussion (Misc queries) | |||
Linear Mode
