excel time function
 

Hi,
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. Can someone please help me.

Nitya

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.