Hi all,

I'm working on a report to catalog tapes coming into a TV station.

The timecodes are stored in the database as a string (00000000)

For the operators to read it properly, I need to add : in every 2 characters so it splits the string as:

00:00:00:00 (Hours, Minutes, Seconds, Frames).

Is there  a pre-existing function that can do this, or is the best way to create an array and then create a new string that adds the array together along with..

& ":" & ?

Many thanks!

Andrew


Edited by andrew - 03 May 2011 at 5:21am

Hi Hilfy - thank you so much, that code works great!