I need to separate date and time form one cell have data like 2021-02-09T09:31:45+05:00

[Ahmed Fawad]

	Date
Date	Time
1	2021-02-09T09:31:45+05:00
2	2021-02-09T09:47:35+05:00
3	2021-02-09T10:39:19+05:00
4	2021-02-09T10:39:19+05:00
5	2021-02-09T10:55:28+05:00

 

[edmitchell]

Hi, can I ask is the content of the date/time column, actually held as Text, or is it a date/time value?

 

[Dave Patton]

What result do you require?
Try either Text to Columns or the formula.
Format the results to your preference.

Date and Time 2021.xlsm
	A	B	C	D	E
4	2021-02-09T09:31:45+05:00	9-Feb-21	09:31:45	05:00:00	14:31:45
5	2021-02-09T09:31:45+05:00	9-Feb-21	09:31:45+05:00
6	2021-02-09T09:31:45+05:00	9-Feb-21	09:31:45+05:00
3d

Cell Formulas
Range	Formula
B4	B4	=--LEFT(A4,10)
C4	C4	=MID(A4,12,8)+0
D4	D4	=MID(A4,LEN(A4)-4,99)+0
E4	E4	=C4+D4

 

[Ahmed Fawad]

What result do you require?
Try either Text to Columns or the formula.
Format the results to your preference.

Date and Time 2021.xlsm
	A	B	C	D	E
4	2021-02-09T09:31:45+05:00	9-Feb-21	09:31:45	05:00:00	14:31:45
5	2021-02-09T09:31:45+05:00	9-Feb-21	09:31:45+05:00
6	2021-02-09T09:31:45+05:00	9-Feb-21	09:31:45+05:00
3d

Cell Formulas
Range	Formula
B4	B4	=--LEFT(A4,10)
C4	C4	=MID(A4,12,8)+0
D4	D4	=MID(A4,LEN(A4)-4,99)+0
E4	E4	=C4+D4

Thank you very much