I'm curious if someone can show me a formula that would convert a couple different variations of time & date formatted cells into correct or usable time and date formats.
Currently, I have one column that has 20180109 05:06 in it and another column that has 20190102-01:13 in it... the only difference between the two is the hyphen. I need those separated into proper date and time columns.
Here's an image of what I'm referring to. I have also attached an example worksheet
Capture.PNG
Bookmarks