Re: [FCP-L] timecode in Excel

For strictly inputing TC (no addition or subtraction), I format the
numbers in the cell like this:

Go to: Format/Cells/Number/Custom... and type in:
00\:00\:00\:00
... then format all the desired cells in your doc that way

When you enter TC in those cells, enter numbers only, i.e.,
12345678 ... which will result in 12:34:56:78 when you tab out of the
cell.

HTH,

---
Bob
------
Robert Griffiths
http://www.FireDancer.tv

On Nov 20, 2009, at 2:50 AM, Rupert Watson wrote:

> I remember a thread a long time ago about this, but I need to be
> able to
> have a field in Excel that allows me to input time-code (ideally
> putting
> in the colons for me). Can anyone let me know where to look for how to
> achieve this painlessly in Excel?
>
>
>
> Rupert Watson
>
> +44 7787 554 801
>
> www.root6.com
>
>
>
>
> ROOT 6 LIMITED
> Registered in the UK at
> 4 WARDOUR MEWS, LONDON
> W1F 8AJ
> Company No. 03433253
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------------------
>
> To learn more about the FinalCutPro-L group, please visit
> http://groups.yahoo.com/group/FinalCutPro-LYahoo! Groups Links
>
>
>

------------------------------------

To learn more about the FinalCutPro-L group, please visit
http://groups.yahoo.com/group/FinalCutPro-LYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/FinalCutPro-L/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/FinalCutPro-L/join
(Yahoo! ID required)

<*> To change settings via email:
FinalCutPro-L-digest@yahoogroups.com
FinalCutPro-L-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
FinalCutPro-L-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/