Combine Date cell with Time Cell in one cell

M

M P

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

Peo Sjoblom

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
 
C

Corey

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