View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default 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