Time comparison throws me

[SandsB]

Column A has date.time in General format. Looks like this:
09/09/21 18:09
09/09/21 18:13
09/09/27 11:03
09/09/28 12:11
09/09/28 12:23
A2-A1 gets the time difference in column C, format is Time 37:30:55 and the result is correct so Excel's reading all this as the correct date and time. But
I need column D to show "Yes" if A2-A1 is greater than 10 minutes but less than 2 days. Blank if both conditions aren't met. Holy mole this is confusing.

 

[SQUIDD]

UNTESTED

But does this work

=IF(AND(A2-A1>TIMEVALUE("00:10:00"),A2<A1+2),"yes","")

 

[SandsB]

UNTESTED

But does this work

=IF(AND(A2-A1>TIMEVALUE("00:10:00"),A2<A1+2),"yes","")

When my feeble brain looks at this it says, yeah - that should work, but it only returns blanks.

 

[SQUIDD]

Ok

Can i just ask, are you saying 2 days is 24 hours, or at this point are you just looking at the date only forgetting the time?

Dave

 

[SQUIDD]

try

=IF(AND(A2-A1>TIMEVALUE("00:10:00"),A2-A1<2),"yes","")

 

[SandsB]

try

=IF(AND(A2-A1>TIMEVALUE("00:10:00"),A2-A1<2),"yes","")

This works great. I still need to look at your original to see understand why it didn't work - seems logical to me. Thank for the help.

 

[SQUIDD]

Great, glad that worked for you.