Home |
Search |
Today's Posts |
#1
|
|||
|
|||
combine date from one column with time from another
I would like to combine the date from one downloaded column with the time
from a second downloaded column. I will be using this to calculate the length of treatment using another column with date/time entered. I am currently manually combining, so there is potential for error. Much thanks. |
#2
|
|||
|
|||
If they are indeed date and times that Excel sees at time you can just add
them, e.g. in A1 01/01/05, in B1 10:24 in C1 =A1+B1 will return 01/01/05 10:24 if the formula gives you a value error then the there are text values involved -- Regards, Peo Sjoblom (No private emails please) "Phyllis Salyers" <Phyllis wrote in message ... I would like to combine the date from one downloaded column with the time from a second downloaded column. I will be using this to calculate the length of treatment using another column with date/time entered. I am currently manually combining, so there is potential for error. Much thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Activating "Todays Date" column upon opening? | Excel Discussion (Misc queries) | |||
search for latest date | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
match and count words | Excel Worksheet Functions | |||
Combined date time cell to separate date & time components | Excel Discussion (Misc queries) |