MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date and Time


Posted by Temieka Smith on August 18, 2000 6:35 AM

The situation is as follows:

I have the date in one column and the time in another. I would like to combine the date and time into one cell. I need to do this for opened, respond and closed. I then need to calculate the the difference between respond and opened and closed and opened.


Posted by Thomas Venn on August 25, 0100 11:12 AM

for date and time, assuming b1=date, and c1=time. =TEXT(B1,"mm/dd/yy")&" "&TEXT(C1,"h:mm:ss AM/PM").

the difference for time is the same as any other calculation of subtraction and addtion.

Cheers,

Thomas