Splitting Date and Time

[Cybertech]

I am sorry for what I am sure is a simple question, but nothing I try seems to work. I have approximately 8000 rows in an excel table formatted as follows:

Date and Time
01/01/2017 0748
01/01/2017 0749
01/01/2017 0750
01/01/2017 0751
01/01/2017 0752

I need to split the date and time into two new columns in the following format:

Date Time
01/01/2017 07:48
01/01/2017 07:49
01/01/2017 07:50
01/01/2017 07:51
01/01/2017 07:52

Any suggestions?

Thanks!

 

[barry houdini]

Assuming first date/time in A2 try the following:

In B2

=LEFT(A2,10)+0

In C2

=REPLACE(RIGHT(A2,4),3,0,":")+0

format B2 and C2 in required date and time formats

 

[Cybertech]

Worked Great

Thanks!!!