Splitting Cell contents

[Reec0n]

Hi all.

A B C

01/06/2018 16:31	01/06/2018 16:42	11 minutes
01/06/2018 16:48	01/06/2018 16:49	a minute
01/06/2018 16:53	01/06/2018 16:54	a minute
04/06/2018 16:44	04/06/2018 16:49	5 minutes
04/06/2018 17:08	04/06/2018 17:19	11 minutes
04/06/2018 17:53	04/06/2018 18:05	12 minutes
04/06/2018 18:19	04/06/2018 18:28	9 minutes
04/06/2018 19:14	04/06/2018 19:27	13 minutes
04/06/2018 20:56	04/06/2018 21:00	4 minutes
04/06/2018 21:04	04/06/2018 21:05	a minute
04/06/2018 21:39	04/06/2018 21:46	7 minutes
04/06/2018 21:58	04/06/2018 22:05	7 minutes
04/06/2018 22:55	04/06/2018 23:02	7 minutes
04/06/2018 23:51	04/06/2018 23:57	6 minutes
05/06/2018 06:42	05/06/2018 06:49	7 minutes
05/06/2018 06:50	05/06/2018 06:52	2 minutes
05/06/2018 14:12	05/06/2018 14:17	5 minutes
05/06/2018 15:12	05/06/2018 15:15	3 minutes
05/06/2018 15:25	05/06/2018 15:34	9 minutes
05/06/2018 17:29	05/06/2018 17:36	7 minutes
05/06/2018 20:26	05/06/2018 20:32	6 minutes
06/06/2018 05:45	06/06/2018 05:47	2 minutes
06/06/2018 10:10	06/06/2018 10:16	6 minutes
06/06/2018 12:34	06/06/2018 12:42	8 minutes
06/06/2018 17:12	06/06/2018 17:17	5 minutes
12/06/2018 15:53	12/06/2018 17:56	2 hours
27/06/2018 14:39	27/06/2018 14:40	a minute

<colgroup><col span="2"><col></colgroup><tbody>
</tbody>

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]

01/06/2018 16:31:19	04/06/2018 21:05:19
04/06/2018 21:39:19	04/06/2018 21:46:19
04/06/2018 21:58:19	04/06/2018 22:05:19

<tbody>
</tbody>

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.