Date and Time Calculation

[karthick.in]

Hi.. Can some one help me to solve the below problem?

I have Column A = Start Date (mm/dd/yy), Column B = Start time (hh:mm:ss AM/PM) and Column C = End Date (mm/dd/yy), Column D = End time (hh:mm:ss AM/PM).
Now in Column E, I would like to have "Yes" if End time is <= 6 hours from the start time and "No" if the time consumed is > 6 hours.

Thanks!

 

[pjmorris]

hi, and welcome to the forum.

Would this work in cell E1: =if(((c1+d1)-(A1+B1))*24<=6,"Yes","No")

Regards

 

[iyyi]

Also ...
=IF(C2+D2-A2-B2>6/24,"No","Yes")