excel time function
"Nitya Satheesh" wrote:
I have a set of dates in one column and a set of different
times in another.If the date is same , I need to check if
there is a difference of 1 mi in the times.
A concrete example might help us understand your requirements more
specifically.
If A1:A100 contains dates and B1:B100 contains times, and if you want to
check only adjacent times and return TRUE (difference of 1 min) and FALSE
(difference of more or less than 1 min), try the following starting in C2
and copying down through C100:
=(A2+B2-(A1+B1)=TIME(0,1,0))
Note: The outer parentheses are not required. But they might make the
intent of the formula easier to understand.
|