Splitting Cell contents

Reec0n

New Member
Joined
Jan 30, 2017
Messages
20
Hi all.

A B C
[TABLE="width: 314"]
<colgroup><col span="2"><col></colgroup><tbody>[TR]
[TD]01/06/2018 16:31[/TD]
[TD]01/06/2018 16:42[/TD]
[TD]11 minutes[/TD]
[/TR]
[TR]
[TD]01/06/2018 16:48[/TD]
[TD]01/06/2018 16:49[/TD]
[TD]a minute[/TD]
[/TR]
[TR]
[TD]01/06/2018 16:53[/TD]
[TD]01/06/2018 16:54[/TD]
[TD]a minute[/TD]
[/TR]
[TR]
[TD]04/06/2018 16:44[/TD]
[TD]04/06/2018 16:49[/TD]
[TD]5 minutes[/TD]
[/TR]
[TR]
[TD]04/06/2018 17:08[/TD]
[TD]04/06/2018 17:19[/TD]
[TD]11 minutes[/TD]
[/TR]
[TR]
[TD]04/06/2018 17:53[/TD]
[TD]04/06/2018 18:05[/TD]
[TD]12 minutes[/TD]
[/TR]
[TR]
[TD]04/06/2018 18:19[/TD]
[TD]04/06/2018 18:28[/TD]
[TD]9 minutes[/TD]
[/TR]
[TR]
[TD]04/06/2018 19:14[/TD]
[TD]04/06/2018 19:27[/TD]
[TD]13 minutes[/TD]
[/TR]
[TR]
[TD]04/06/2018 20:56[/TD]
[TD]04/06/2018 21:00[/TD]
[TD]4 minutes[/TD]
[/TR]
[TR]
[TD]04/06/2018 21:04[/TD]
[TD]04/06/2018 21:05[/TD]
[TD]a minute[/TD]
[/TR]
[TR]
[TD]04/06/2018 21:39[/TD]
[TD]04/06/2018 21:46[/TD]
[TD]7 minutes[/TD]
[/TR]
[TR]
[TD]04/06/2018 21:58[/TD]
[TD]04/06/2018 22:05[/TD]
[TD]7 minutes[/TD]
[/TR]
[TR]
[TD]04/06/2018 22:55[/TD]
[TD]04/06/2018 23:02[/TD]
[TD]7 minutes[/TD]
[/TR]
[TR]
[TD]04/06/2018 23:51[/TD]
[TD]04/06/2018 23:57[/TD]
[TD]6 minutes[/TD]
[/TR]
[TR]
[TD]05/06/2018 06:42[/TD]
[TD]05/06/2018 06:49[/TD]
[TD]7 minutes[/TD]
[/TR]
[TR]
[TD]05/06/2018 06:50[/TD]
[TD]05/06/2018 06:52[/TD]
[TD]2 minutes[/TD]
[/TR]
[TR]
[TD]05/06/2018 14:12[/TD]
[TD]05/06/2018 14:17[/TD]
[TD]5 minutes[/TD]
[/TR]
[TR]
[TD]05/06/2018 15:12[/TD]
[TD]05/06/2018 15:15[/TD]
[TD]3 minutes[/TD]
[/TR]
[TR]
[TD]05/06/2018 15:25[/TD]
[TD]05/06/2018 15:34[/TD]
[TD]9 minutes[/TD]
[/TR]
[TR]
[TD]05/06/2018 17:29[/TD]
[TD]05/06/2018 17:36[/TD]
[TD]7 minutes[/TD]
[/TR]
[TR]
[TD]05/06/2018 20:26[/TD]
[TD]05/06/2018 20:32[/TD]
[TD]6 minutes[/TD]
[/TR]
[TR]
[TD]06/06/2018 05:45[/TD]
[TD]06/06/2018 05:47[/TD]
[TD]2 minutes[/TD]
[/TR]
[TR]
[TD]06/06/2018 10:10[/TD]
[TD]06/06/2018 10:16[/TD]
[TD]6 minutes[/TD]
[/TR]
[TR]
[TD]06/06/2018 12:34[/TD]
[TD]06/06/2018 12:42[/TD]
[TD]8 minutes[/TD]
[/TR]
[TR]
[TD]06/06/2018 17:12[/TD]
[TD]06/06/2018 17:17[/TD]
[TD]5 minutes[/TD]
[/TR]
[TR]
[TD]12/06/2018 15:53[/TD]
[TD]12/06/2018 17:56[/TD]
[TD]2 hours[/TD]
[/TR]
[TR]
[TD]27/06/2018 14:39[/TD]
[TD]27/06/2018 14:40[/TD]
[TD]a minute[/TD]
[/TR]
</tbody>[/TABLE]


I have time and date in cells a and b.

I would like to split the date and time into separate cells to end up with

A B C D E
Time Date Time Date Duration

any help welcomed.

Tia
 

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.
Hi,

Thanks for a quick reply,

This isnt working for me - its just doing maths:confused:

Can you provide an example of how I can split the time and date into their own cells

Apologies if I'm confusing things further

As dates and times are just numbers to excel you can use:

=B1-A1
 
Upvote 0
Sure its doing maths. As i said date/ times are just numbers to excel. One minus the other will produce the difference between the two. Why would you want to split the dates up?
 
Upvote 0
[TABLE="width: 500"]
<tbody>[TR]
[TD]01/06/2018 16:31:19[/TD]
[TD]04/06/2018 21:05:19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]04/06/2018 21:39:19[/TD]
[TD]04/06/2018 21:46:19[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]04/06/2018 21:58:19[/TD]
[TD]04/06/2018 22:05:19[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Hopefully this will provide some clarity.

I need to separate the time from the dates.

I want the date in one cell and the time in another. So instead of two columns, I would like to see 4.

Arranged Date Time Date Time

Hope that helps


Sure its doing maths. As i said date/ times are just numbers to excel. One minus the other will produce the difference between the two. Why would you want to split the dates up?
 
Upvote 0
Ok you do that using:

=INT(A1)

format to date and

=A1-INT(A1)

format to time.
 
Upvote 0

Forum statistics

Threads
1,224,823
Messages
6,181,179
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top