number formatting time codes

Is there a way that you can have a custom number format so
that the figures are displayed as

Hours
Minutes
Seconds
Frames (25 frames per second)

The nearest I can get is 100th of a second. But I need
the frames to be 25.

Any ideas
H.

This might help you

http://www.belle-nuit.com/timecode/

--

Regards,

Peo Sjoblom


"Helen Farmer" wrote in message
...
Is there a way that you can have a custom number format so
that the figures are displayed as

Hours
Minutes
Seconds
Frames (25 frames per second)

The nearest I can get is 100th of a second. But I need
the frames to be 25.

Any ideas
H.

thanks for that.

What do I download and to where?

H.
-----Original Message-----
This might help you

http://www.belle-nuit.com/timecode/

--

Regards,

Peo Sjoblom


"Helen Farmer"
wrote in message
...
Is there a way that you can have a custom number format
so
that the figures are displayed as

Hours
Minutes
Seconds
Frames (25 frames per second)

The nearest I can get is 100th of a second. But I need
the frames to be 25.

Any ideas
H.



.

Maybe it is easier if you download a trial version of John Walkenbach's
pup2000, it has a manual etc..

http://j-walk.com/ss/pup/pup2000/

--

Regards,

Peo Sjoblom


"Helen Farmer" wrote in message
...
thanks for that.

What do I download and to where?

H.
-----Original Message-----
This might help you

http://www.belle-nuit.com/timecode/

--

Regards,

Peo Sjoblom


"Helen Farmer"
wrote in message
...
Is there a way that you can have a custom number format
so
that the figures are displayed as

Hours
Minutes
Seconds
Frames (25 frames per second)

The nearest I can get is 100th of a second. But I need
the frames to be 25.

Any ideas
H.



.

The most recent version is PUP v5. It has several custom "TIMEXX" functions
that work with SMPTE time values. When you install the functions in a
workbook, they will continue to work even after the 30-day trial expires.

http://j-walk.com/ss/pup/pup5/index.htm

John Walkenbach
For Excel tips, macros, & downloads...
http://j-walk.com/ss


"Peo Sjoblom" wrote in message
...
Maybe it is easier if you download a trial version of John Walkenbach's
pup2000, it has a manual etc..

http://j-walk.com/ss/pup/pup2000/

--

Regards,

Peo Sjoblom


"Helen Farmer" wrote in message
...
thanks for that.

What do I download and to where?

H.
-----Original Message-----
This might help you

http://www.belle-nuit.com/timecode/

--

Regards,

Peo Sjoblom


"Helen Farmer"
wrote in message
...
Is there a way that you can have a custom number format
so
that the figures are displayed as

Hours
Minutes
Seconds
Frames (25 frames per second)

The nearest I can get is 100th of a second. But I need
the frames to be 25.

Any ideas
H.



.