Posted to microsoft.public.excel.programming

Steve[_42_] Steve[_42_] is offline

external usenet poster

Posts: 9

import data time format

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
import data format	thenight-train	Excel Worksheet Functions	2	January 27th 09 11:49 PM
Import data from website everyday at certain time...	Jambruins	Excel Discussion (Misc queries)	2	November 15th 07 05:32 PM
Import data format, need help	sunslight	Excel Discussion (Misc queries)	1	July 8th 06 08:20 PM
Import csv data and convert to TIME format	JLettington	Excel Worksheet Functions	0	January 25th 06 03:34 PM
how do i import multiple data sets at one time?	chris_rip	Excel Discussion (Misc queries)	3	June 22nd 05 04:27 AM

All times are GMT +1. The time now is 03:33 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us