NotTheBestTool
New Member
- Joined
- Mar 2, 2022
- Messages
- 16
- Office Version
- 2016
- Platform
- Windows
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 |