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)