Video Time Format

[Guest]

I am a videographer and need to enter time in a format of hh:mm:ss:ff where
ff means frames. Usually, I shoot 30 frames per second so the ff needs to be
modulo 30. However, it would be nice to be able to change the modulo number
because some video work is at different frame rates, e.g. 24 frames per
second, i.e. modulo 24. There should not be an AM or PM associated with this
format.

 

[David McRitchie]

Use Google Groups: http://groups.google.com/advanced_search
place the following into the search box:
hh:mm:ss:ff group:*excel*

 

[Guest]

Thanks for your reference to the other site. I've entered the code found at
that site by right clicking the tab and pasting. But now what? How do I
invoke this code? I'm not at all familiar with using VB.

 

[David McRitchie]

Hi Sam,
I was hoping you would find your own solution.

I gave you a reference to Google Groups search, which searches all
of the Excel newsgroup postings for a string (string of characters). I have no idea
from which of the 26 threads (as of your posting) that you chose. I think it unlikely that you
chose an event macro which what you would be installing by right-clicking on the sheet tab..

I expect you probably chose a user defined function, which would be installed in
a module. See
Getting Started with Macros and User Defined Functions
Use someone else's macro (#havemacro)
http://www.mvps.org/dmcritchie/excel/event.htm#havemacro

I expect you chose something like the first thread that I saw, Wade's reply in
http://groups.google.com/groups?threadm=ukprBTLfBHA.1368@tkmsftngp05

 

[Guest]

Your guess was exactly correct regarding which solution I was looking at -
sorry for the ambiguity! I'll this as a user defined macro. Thanks so much
for your time and help.