In each of the rows in Table 2 are strings of characters containing a date and time. Without using the Text to Columns function, extract the date (in

[NotTheBestTool]

Excel Exam - Reporting Analyst.xlsb
	C	D	E	F	G	H	I	J	K	L	M
46	In each of the rows in Table 2 are strings of characters containing a date and time. Without using the Text to Columns function, extract the date (in date format) and time (in time format) as shown in the sample output on the right.
47
48
49	Table 2.				Sample Output
50	String	Date	Time
51	385;2018-11-29 01:15:45;592
52	384;2018-12-02 07:34:51;309
53	382;2018-11-23 12:41:01;503
54	381;2018-11-25 17:04:50;463
55	380;2018-12-01 14:21:07;380
Questionnaire

 

[RoryA]

Homework?

 

[NotTheBestTool]

Homework?

Not really, I'm too old for that. This was a challenge from a colleague. It's supposed to help me improve my Excel skill. I just could not figure out what function to use for this.

 

[RoryA]

Have a look at MID, TIMEVALUE and DATEVALUE

 

[NotTheBestTool]

Have a look at MID, TIMEVALUE and DATEVALUE

? Thank you. I was able to do it.

 

[RoryA]

Glad we could give you a steer in the right direction.