im trying to extract time date from:

05:20:2006:18:45:50

i could use the mod function but the data is not in date time format.

How to i convert the above into date time format so that i can extract
the time data from it?

thanks