import data time format

[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.

 

[J.E. McGimpsey]

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

 

[Steve]

Perfect, Thanks.

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