Date format and difference in time

I have a log that creates date like 20130221:19:24:50:026666. I ultimately want to convert that into a date/time and do a date diff function on that date and another like it to get the elapsed time.

I tried just splitting it into date and time and the date part 20130221 with custom format of yyyymmdd, but it just returns ########## in the cell.

Is there a way to convert the whole thing into a date/time where I can then subtract from another and get elapsed time. If not, is there just a way to create the date format and time format? I does not seem to work.

Thanks,
Tim

Thanks a bunch, that worked for formatting.

Now how would I do a difference of those dates to show that the elapsed time between them was 5 hours 4 minutes and 4 seconds?

Thanks in adavance,

Tim