Separate Date & Time data into 2 different cells

**edwinkbell** · 08-10-2009, 07:16 AM

I have a cell with both date & time and I need to separate this into 2 separate cells, 1 for the date and 1 for the time.

Sample is attached for the before and after formats.

Thanks.

**Special-K** · 08-10-2009, 07:45 AM

To extract date =INT(B5)
To extract time =MOD(B5,1)

Make sure date and time cells are formatted appropriately and it will give you want you want

**edwinkbell** · 08-10-2009, 08:31 AM

Thanks Special-K,
That was just what I needed...

**arthurbr** · 08-10-2009, 08:48 AM

Anon formula solution :

data - text to column - use space as delimiter - ok

**ihunnur** · 06-14-2013, 03:13 AM

I did not get it.
How to separate date & time in 2 different cells

**jwalvarez** · 11-28-2014, 09:24 AM

Is there a formula that I can use to group a set of “time”.
For example:
12:01 PM
12:15 PM
1:05 PM
2:18 PM
2:20 PM
1:08 PM

Then I want to group them into these intervals
12:00PM-12:30PM
12:31PM-1:00PM
1:01PM-1:30PM
1:31PM-2:00PM
2:01PM-2:30PM

Hope you can help me with this. Thanks in advance!