| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I join a date and time that are in separate columns?
I want to calculate the difference between two dates and times but my date
and time colums are separate. Is there an easy way to join them. Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I join a date and time that are in separate columns?
A1=Date
B1=Time C1: =A1+B1 "jenn" wrote: I want to calculate the difference between two dates and times but my date and time colums are separate. Is there an easy way to join them. Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I join a date and time that are in separate columns?
Jen,
Try: =(C1&D1)-(A1&B1) c1 d1 are the later date and time a1 b1 are the earlier. Mike "jenn" wrote: I want to calculate the difference between two dates and times but my date and time colums are separate. Is there an easy way to join them. Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I join a date and time that are in separate columns?
Add them
=A1+B1 then format as date and time -- Regards, Peo Sjoblom "jenn" wrote in message ... I want to calculate the difference between two dates and times but my date and time colums are separate. Is there an easy way to join them. Thanks |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I join a date and time that are in separate columns?
I can't beleive it is that easy I have been trying to figure this out for a
while trying concatenate and text and other stuff. Thank you so much "Toppers" wrote: A1=Date B1=Time C1: =A1+B1 "jenn" wrote: I want to calculate the difference between two dates and times but my date and time colums are separate. Is there an easy way to join them. Thanks |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I join a date and time that are in separate columns?
Thanks for your quick reply that is great
"Mike H" wrote: Jen, Try: =(C1&D1)-(A1&B1) c1 d1 are the later date and time a1 b1 are the earlier. Mike "jenn" wrote: I want to calculate the difference between two dates and times but my date and time colums are separate. Is there an easy way to join them. Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Elapsed time when separate cells contain time and separate date | New Users to Excel | |||
| Merging separate date and time columns into one | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Linear Mode
