Split cell into 2 cells

[k00lfire]

i have to split below into separate cell for date and time and so that time used can be calculated







5/1/2015 16:50 5/1/2015 17:50
5/1/2015 20:44 5/1/2015 21:44
5/2/2015 23:35 5/3/2015 0:35
5/3/2015 14:23 5/3/2015 16:09
5/5/2015 1:04 5/5/2015 2:04
5/5/2015 14:24 5/5/2015 18:04
5/5/2015 22:54 5/5/2015 23:54

 

[Chrisdontm]

It looks like there are 2-dates & 2-times in each cell, is that so...?

Or is there 1-date & 1-time in each cell...?

 

[k00lfire]

only 2 cells each having time and date

5/1/2015 16:50 5/1/2015 17:50
5/1/2015 20:44 5/1/2015 21:44
5/2/2015 23:35 5/3/2015 0:35
5/3/2015 14:23 5/3/2015 16:09
5/5/2015 1:04 5/5/2015 2:04
5/5/2015 14:24 5/5/2015 18:04
5/5/2015 22:54 5/5/2015 23:54

 

[Rick Rothstein]

only 2 cells each having time and date

5/1/2015 16:50 5/1/2015 17:50
5/1/2015 20:44 5/1/2015 21:44
5/2/2015 23:35 5/3/2015 0:35
5/3/2015 14:23 5/3/2015 16:09
5/5/2015 1:04 5/5/2015 2:04
5/5/2015 14:24 5/5/2015 18:04
5/5/2015 22:54 5/5/2015 23:54

I don't think you have to split anything then, assuming cells A1 and B1 for the first line...

=1440*(B1-A1)

will give you the number of minutes difference between them.