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

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

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

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

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

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