I have a gridview control with a date/time column. It's quite old and was free with a magazine but it does the job...almost. It won't let me format the column to just time. It has to be date and time. If the user puts in a time without the colon, e.g. 1730 instead of 17:30, the program crashes.

That's my scenario. What I need is a function that puts in a colon after the first two digits of a time field if they don't exist.

This would help me out considerably.

Thanks.