Formating

[sweet_taters]

I am a video editor and don't know a lot about excel. I am trying to format cells so they display nubers in timecode form, etc.
00:01:05:15

Is there some way i can just type in 8 numbers and have excel put in the colons for me and my clients

thanks so much
eric

 

[badnazzz]

I THINK I FIGURED IT OUT.

 

[lenze]

GOOD!! One of the best ways to learn VBA is to take coding from the board and modify it to your needs. Good luck. Post again if you need help!

lenze

 

[Mom Shoe]

custom cell format time if using for function

How do I use the 00":"00 custom cell format when I want to add or multiply or count the cells?