import data time format

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi, I have imported some data into excel from a text file.

Column1: date (mm:dd:yy)
column2 : time eg 1500 (24 hour time, however only imported a string)

What I need to do is combone these two columns into a single column that
consists of date & time.
eg 03/15/2003 3:00:00 PM

Is this possible?

Thank you.
 
One way:

In column C, enter:

C1: =TIME(B1/100, MOD(B1,100),0)

and copy down as far as necessary.

Select the cells in column C. Copy them.

Select the corresponding cells in column A. Choose Edit/Paste
Special and select the Values and Add Radio buttons.

Format the cells in column A as

mm/dd/yyyy h:mm:ss AM/PM
 
Perfect, Thanks.

J.E. McGimpsey said:
One way:

In column C, enter:

C1: =TIME(B1/100, MOD(B1,100),0)

and copy down as far as necessary.

Select the cells in column C. Copy them.

Select the corresponding cells in column A. Choose Edit/Paste
Special and select the Values and Add Radio buttons.

Format the cells in column A as

mm/dd/yyyy h:mm:ss AM/PM
Click to expand...
 
Back
Top