Convert Time code script

[Erik J bartelt]

Hi All

This my little problem. I have a time code field which has a colon then two digits follow, something of this nature ":30". I need to and a zero in front of the colon which would be this "0:30". The two digits following are random from 0 to 60 seconds. I am at a loss on trying scripts I wrote. I am new at script writing. I have about 100,000 records which need to be converted.

Thanks for the help!!

[Vaughan]

You probably need a calculation that does the text string manipulation. Look into the Position() function and the Left() and Right() functions.