Thanks Jake!!
Hafeez Esmail
-----Original Message-----
Hi Hafeez,
Assuming the two dates are in A1 and A2 and the
corresponding times are in
B1 and B2, this formula should do what you're looking for:
=ABS((A1+B1)-(A2+B2))<=TIME(0,2,0)
--
Regards,
Jake Marx
MS MVP - Excel
www.longhead.com
[please keep replies in the newsgroup - email address
unmonitored]
Hafeez Esmail wrote:
I want to see if two times are <= 2 minutes. Is there a
function that does this (and takes the case where time1
=
23:58:01 and time2 = 0:00:01)?
Col A contains Dates and Col B contains Time
Thanks
Hafeez Esmail
.