ExcelUserZero
New Member
- Joined
- Jan 18, 2018
- Messages
- 6
Good morning,
I have a set of data that I imported into Excel. The date and time comes in one cell, but in the format: Sep 19 2017 10:08AM. I used the =Right and =Left functions to separate the date from the time, but now I am stuck with how to convert these to actual values. I have tried messing around with =datevalue and =timevalue.
Thank you in advance for your help!
I have a set of data that I imported into Excel. The date and time comes in one cell, but in the format: Sep 19 2017 10:08AM. I used the =Right and =Left functions to separate the date from the time, but now I am stuck with how to convert these to actual values. I have tried messing around with =datevalue and =timevalue.
Thank you in advance for your help!