Splitting Cell contents

[Reec0n]

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

 

[steve the fish]

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

=B1-A1

 

[Reec0n]

Hi,

Thanks for a quick reply,

This isnt working for me - its just doing maths

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

 

[steve the fish]

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?

 

[Reec0n]

[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?

 

[steve the fish]

Ok you do that using:

=INT(A1)

format to date and

=A1-INT(A1)

format to time.