Would you be allowed to use DATE() and TIME() function in conjunction with MID() to extract each date and time element and feed it into a formula so that Excel can convert the string to a proper date/time serial number?

=DATE(MID(A1,5,4),MID(A1,9,2),MID(A1,11,2)) in B1 for the date portion.
=TIME(MID(A1,14,2),MID(A1,16,2),0) in C1 for the time portion?