Hi Hafeez

Subtract time like this (with start time in A1 and end time in B1)
=(B1-A1+(B1<A1))
For your need (<= 2 minutes) :
=(B1-A1+(B1<A1))<=(1/720)

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Hafeez Esmail" skrev i melding
...
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