Countifs with condition and interval range

[marea69]

Hello
I have a problem with function Countifs (maybe)

Column A: Employed Names
Column B: Hours
Column C: "Criteria"


"A" "B" "C"
BOB 10:00 AM DOUBLE
MARY 11:00 AM DOUBLE
GEORGE 12:00 PM
BOB 1:00 PM DOUBLE
MARY 11:15 AM DOUBLE

at present the function for C1 is:
=IF(COUNTIF(A:A,A:A)>1,"DOUBLE ","")

i would like it to be calculated the condition only if the value of cell B1 is less than one hour (or 60')

Thank you in advance

[etaf]

countifs(A:A,A2,B:B, ??

Are looking for the time difference between duplicates ?
Mary = 11:00 AM & 11:15AM so thats less than 60 minutes
BUT BOB is over 1 hr
Are they only duplicated , or can the names appear multiple times
IF so are they ordered in Time Order at all ?

[marea69]

Names can appear up to 2 times a day
but they cannot appear 2 times in less than an hour

[etaf]

Names can appear up to 2 times a day
but they cannot appear 2 times in less than an hour

Is that what you are trying to fix, or is that the data set
If its the data set, then it will not be less than an hour

I was asking about the data set you have

[marea69]

exactly like the file I attached.
The only input takes place in column A via barcode scanner
The rest happens automatically.

I am creating an access control manager for the company canteen.
Therefore I would like Bob (for example) to be able to eat for lunch and dinner (2 times), but he cannot eat 2 times in less than an hour (double stamping)

[etaf]

This only shows the first double entry - not the last one , but will work for multiple entries
=IFERROR(IF(AND(COUNTIF(A2:$A$100,A2)>1,(INDEX(B3:$B$100,MATCH(A2,A3:$A$100,0))-B2)<=TIMEVALUE("01:00"),(INDEX(B3:$B$100,MATCH(A2,A3:$A$100,0)))>TIMEVALUE("00:00")),"Double <1hr",""),"")

I'm sure there is a better way

But this was done before you submitted a sample sheet

[marea69]

The second solution you sent me is fine.
I think I solved it this way.

Thank you very much

[etaf]

you are welcome,
I'm sure there is a way to highlight both entries with a simple formula