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)

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)