As long as frames are always zero, you can achieve what you want by:

1. Convert to an excel time by dividing by 86400 (the number of seconds in a
day)
2. Custom format as hh:mm:ss".00"

--
Regards,
Fred


"SAPOL AVU" <SAPOL wrote in message
...
I have been given a spreadsheet log of over 1100 audio files, with the
duration of each file given in seconds( eg '57').
I need to convert the seconds to timecode for import into a video editing
application.

Eg 57 needs to display as '00:00:57:00', (hours, minutes, seconds, FRAMES,
with colons as separators).
82 seconds needs to display as '00:01:22:00'

The frames info will always be '00', as will the hours info.

Can you please assist with a code that will do this, or point me in the
right direction?

Thankyou,

Jake (South Australia Police Audio Visual Unit)