Archive of Mr Excel Message Board


Back to Dates in Excel archive index
Back to archive home



Combine date and time columns

Posted by Tracey on January 25, 2001 6:41 PM
Here's one that has been driving me nuts! I have several very large files that have the date (01/01/01)
in one column and the time (14:30:25)in another.
I need some way of combining these two values into
one column so that the output will be recognized as
a date/time format (ex. 01/01/01 14:30:00) for
graphing purposes. Using the ampersand seems to code
it as text and I just get out a number (ex. 36892)
that is related to the date, but I cannot get Excel
to format the new cell with the proper date/time
readout. Any suggestions????

Thanx, Tracey


Re: Combine date and time columns

Posted by Celia on January 25, 2001 7:08 PM

Try using + instead of an ampersand, and format as mm/dd/yy hh:mm:ss

Celia




This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.