How do I join a date and time that are in separate columns?

J

jenn

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
 
M

Mike H

Jen,

Try:

=(C1&D1)-(A1&B1)

c1 d1 are the later date and time
a1 b1 are the earlier.

Mike
 
J

jenn

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
 
Top