tonyrensya
New Member
- Joined
- Jul 24, 2013
- Messages
- 21
- Office Version
- 2019
- Platform
- Windows
- MacOS
Hello all,
I'm facing a problem in extracting time from raw data, which the reference and expected result are as below.
If slot is a text, retrieve start time and end time in Result A and B
if Slot is a letter, reference to the table below and output start time and end time in Result A and B
Thank you very much!
I'm facing a problem in extracting time from raw data, which the reference and expected result are as below.
If slot is a text, retrieve start time and end time in Result A and B
Slot | Result A | Result B |
09:00-15:00 | 09:00 | 15:00 |
A | 08:00 | 12:00 |
P | 18:00 | 24:00 |
if Slot is a letter, reference to the table below and output start time and end time in Result A and B
Start time | End time | |
A | 09:00 | 12:00 |
P | 18:00 | 24:00 |
Thank you very much!