Not as easy as my google searches are showing me. I've been trying various =date, =datevalue, Text to columns to convert a text-based date/time originally saved in a CSV.
I'm trying to separate the time from the date so I can pick out blocks of time. So what I do either doesn't work or messes up with the AM/PM. I think I've started to look too much into it.
Link to file on my Google Drive so the bad formatting keeps - https://drive.google.com/open?id=1_fzDVWZINZSaq5v_4ZvoC2xzNKnePmMZ
<tbody>
</tbody>
I have a list of just over 8800 lines to do.
Thank You
I'm trying to separate the time from the date so I can pick out blocks of time. So what I do either doesn't work or messes up with the AM/PM. I think I've started to look too much into it.
Link to file on my Google Drive so the bad formatting keeps - https://drive.google.com/open?id=1_fzDVWZINZSaq5v_4ZvoC2xzNKnePmMZ
Original | Date | Time | |
11/20/2018 4:34:50 PM | 11/20/2018 | 16:34:50 |
<tbody>
</tbody>
I have a list of just over 8800 lines to do.
Thank You