Need help converting a text field to a date Time field that can be used in calculations

Hello,

I'm importing a text file that each row includes a string of numbers such as 201407221430 that represents 7/22/2014 2:30 pm. I need to calculate the elapsed time between rows. I'm importing it using the Get Data from Text option and I cant seem to get the field in question the correct format.

Thanks in advance

Assuming the string is in cell A1, you could use the below to do the trick.

=DATE(LEFT(A1,4),MID(A1,5,2),MID(A1,7,2))+TIME(MID(A1,9,2),RIGHT(A1,2),0)

Seems a bit long winded. I'm sure someone that is more awake than I am right now can provide a much neater answer...

Works like a Charm!!!!! Thank you.

No worries. Happy to help.

Feel free to mark the thread as SOLVED if you're happy with the solution.
But keep an eye out for a better one...