Combine Date cell with Time Cell in one cell

's Computer Specifications

sample data:

Date_Field Time_Field Combined_Field
06/01/2006 06:01:11 06/01/2006 06:01:11
06/01/2006 09:01:29 06/01/2006 09:01:29

hope you might help.

's Computer Specifications

Add them, if they would be in A1 and B1, in C1 use

=A1+B1

then format as mm/dd/yyyy hh:mm:ss

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

"M P" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> sample data:
>
> Date_Field Time_Field Combined_Field
> 06/01/2006 06:01:11 06/01/2006 06:01:11
> 06/01/2006 09:01:29 06/01/2006 09:01:29
>
>
> hope you might help.
>
>
>

's Computer Specifications

A1=06/01/2006 B1= 06:01:11 C1=06/01/2006 06:01:11
A2= 06/01/2006 B2= 09:01:29 C2=06/01/2006 09:01:29

Column C to (A1+B1) and Format data to d/mm h:mm [Right Click C
Column-Format Cells-Under Number Tab Select Custom-Pick (d/mm/yy h:mm) ]

Corey....

"M P" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> sample data:
>
> Date_Field Time_Field Combined_Field
> 06/01/2006 06:01:11 06/01/2006 06:01:11
> 06/01/2006 09:01:29 06/01/2006 09:01:29
>
>
> hope you might help.
>
>
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
cell format for date/time in same cell excel 2003	=?Utf-8?B?U2FuZHk=?=	Microsoft Excel Worksheet Functions	1	18th Jan 2006 03:46 AM
how do i combine a date cell and a time cell in excel?	=?Utf-8?B?U2Vhc29u?=	Microsoft Excel Misc	3	6th Dec 2005 11:09 PM
combine cell value (alpha) with number for cell address	=?Utf-8?B?c2hhemFtZ2Vycnk=?=	Microsoft Excel Programming	1	1st Aug 2005 03:30 AM
combine date & time in one cell	Dawn	Microsoft Excel Discussion	3	26th Jul 2004 04:03 PM
Combine date and time to a single cell	=?Utf-8?B?TWVn?=	Microsoft Excel Misc	1	6th Apr 2004 07:42 AM