Trying to separate date and time format

Question

I have a spreadsheet that was exported in CSV format from an iOS app.  In the app, the date and time are two separate fields.  In the the CSV file, the date and time have been exported as d/m/yyyy h:mm.  I am attempting to import the data into another windows program.  The windows program needs the date in one column and the time in a separate column.  I thought if I copied the date/time column into a new column and formatted as h:mm AM/PM this would solve the problem.  Unfortunately although the column shows only the time, the format bar shows that the date is still included in the field.  How do I fix this so that the date no longer exists in the time column?

Answer 1

See screen shot

Note columns C and D were given appropriate formats

If in D1 you get something like 1 jan 1900 8:00 AM , just give it a Time format

best wishes

Answer 2

Hi,

You may also select the dataset and go to Data > Text to columns > Delimited > Next > Space > Next > Finish.  Now apply the correct formatting on the two additionally created columns.

Answer 3

Thank you Bernard Liengme this did exactly what I needed.  Very much appreciated.