excel time function

  • Thread starter Thread starter Nitya Satheesh
  • Start date Start date
N

Nitya Satheesh

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
 
Nitya Satheesh said:
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.
Click to expand...

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.
 
Back
Top