changing seconds to timecode

[SAPOL AVU]

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)

 

[Fred Smith]

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"

 

[Fred Smith]

Sorry, I meant a custom format of hh:mm:ss":00"