| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CONCATENATING DATE AND TIME | Excel Worksheet Functions | |||
| How to calculate Date & Time differences | Excel Worksheet Functions | |||
| Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
| How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
| Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Linear Mode
