CONCATENATING DATE AND TIME
Try just adding them. Example:
1/12/2005 7:30 AM 1/12/2005 7:30 in cols A,B,C -- Gary''s Student "bladelock" wrote: How can I combine two columns to one new column Example: (i'm trying to find "C") A B C [Date] [Time] [Both] 01/01/2005 14:45:00 01/01/2005 14:45:00 I need column "C" to be a format as mm/dd/yyy hh:mm:ss I tried Concatenaing("A1", "B1") but I get a bunch of numbers can anyone help? |
All times are GMT +1. The time now is 05:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com