Repeat Caller within 24 hour period Formula

[BongoMan]

Hi All,

I am just looking for some help in relation to a formula that has been wrecking my head for a few days now.
Basically what I have is a list of numbers and the date and time they called in. In the next 3 columns I have another list of numbers that called in the following day. what I want to see is if a mobile number has called previously within 24 hours so for e.g. F2 has number 770011111 and this number has called in the past 24 hours (cell F25) When I check to see if 770011111 has called back in in Cell F25, it has not called back in within the last 24 hours. I want it to look backwards and NOT count the number of times it has called in within a 24 hour period. If that makes sense. Sample file attached.

Thanks in advance

[AliGW]

Please add your expected outcomes and explanations to the sample sheet.

[vivek123]

try this
paste it in I2 cell , if it is within 24 hr and falls in same day it returns "Repeat Call Within 24 Hours" or if doesn't it returns #N/A.

=IF(IF(G2=INDIRECT("G"&MATCH(F2,F3:$F$61,0)+ROWS($I$1:I2)),(H2-INDIRECT("H"&MATCH(F2,F3:$F$61,0)+ROWS($I$1:I2)))<"00:00:00",NA()),$I$1).