Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine cells date time
Does anyone know how to combine dates and times that are in two different
columns into one column!? I know that dates and times are really just a series of numbers and when I use the CONCATENATE function it does add those values together but I'm stumped as to how to get the column to show the date and time separately. I've got over 100K lines of data so a shortcut would really help |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine cells date time
Not sure what you're asking, but:
A1 = 10/17/2006 B1 = 10:00 PM =A1+B1 Choose one of the formats you like. Biff "Stumped" wrote in message ... Does anyone know how to combine dates and times that are in two different columns into one column!? I know that dates and times are really just a series of numbers and when I use the CONCATENATE function it does add those values together but I'm stumped as to how to get the column to show the date and time separately. I've got over 100K lines of data so a shortcut would really help |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Combine Date & Time Cells | Excel Discussion (Misc queries) | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) | |||
Help - Information with time and date | Excel Discussion (Misc queries) |