| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combining date and time data
Hi,
I have two columns. One has a date and the other has the time. I would like to combine these two points in one cell [date time]. Can anyone tell me how? Thanks, Nathan |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining date and time data
C1=A1+B1
-- Gary''s Student - gsnu200795 "Nathan" wrote: Hi, I have two columns. One has a date and the other has the time. I would like to combine these two points in one cell [date time]. Can anyone tell me how? Thanks, Nathan |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining date and time data
Just add the two cells together... =A1+A2 assuming the date is in A1 and the
time is in A2. Rick "Nathan" wrote in message ... Hi, I have two columns. One has a date and the other has the time. I would like to combine these two points in one cell [date time]. Can anyone tell me how? Thanks, Nathan |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combining date and time data
You can try a few things:
enter '=now()' into your cell and format as 'm/d/yyyy h:mm' If you want to calculate a short difference in time, such a certain number of days, try this: =INT(A2-A1)&"d "&TEXT(MOD((A2-A1),1),"h:mm:ss") If you want to calculate a short difference in time, such a certain number of days, try this: =DATEDIF(A1,A2,"y")&" years "&DATEDIF(A1,A2,"ym")&" months "&DATEDIF(A1,A2,"md")&" days" Regards, Ryan--- -- RyGuy "Nathan" wrote: Hi, I have two columns. One has a date and the other has the time. I would like to combine these two points in one cell [date time]. Can anyone tell me how? Thanks, Nathan |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combining date and time into one cell | Excel Discussion (Misc queries) | |||
| Filter date time data | Excel Discussion (Misc queries) | |||
| Data Entry date/time? | Excel Discussion (Misc queries) | |||
| Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
| Time "and" Date for data points | Charts and Charting in Excel | |||
Linear Mode
