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