excel date time

By ddaa ·
I have imported some data in excel and one of the cells contain date and time(01 06 2007 12:38:45).How do I split date in one and time in other cell.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Copy the cell, then right-click & change format of each.

by Absolutely In reply to excel date time
Collapse -

Use Text to Columns

by coolsabby In reply to excel date time

Highlight the entire column of data then use the Text to Columns option under the Data tab. Play around between the Delimited and Fixed Width options to see what works for you. Keep in mind that if you separate one column into two (or more) it may overwrite into the next columns, so insert some blank columns first.

Collapse -

Insert a column, do a formula

by DelbertPGH In reply to excel date time

Excel stores every date with a nominal time. It's inescapable. You can, however, choose to show only the date portion, or only the time portion. You can also convert date and/or time into text strings.

Insert a column next to the date (suppose the date is in D; insert a new column E.) Copy all the data in column D into E (either a copy-paste the whole column, or put a formula in each cell of E, =D1, =D2, =D3, etc.) Format each column to show either date or time.

You can create a text string representation of the time, =TEXT(D2,"HH:MM"), or =TEXT(D2,"YYYY-MMM-DD"). However, you can't do time math on this, such as subtracting one time from another to find the elapsed minutes.

Related Discussions

Related Forums