Is there a TimeDiff function?
=Mod(A2-A1,1)<=TimeValue("00:02:00")
Assumes the start time is in A1 and End time in A2
--
Regards,
Tom Ogilvy
"Hafeez Esmail" wrote in message
...
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
|