Representing a new measurement taken 2-4 hours after the initial measurement

[Lifeseeker]

Hi there,

How do I represent this logic in the query grid?

col a is the first measurement and col b is the 2nd measurement

What I want:

Ones where the 2nd measurement is taken 2-4 hours after the initial measurement.

what should the formula look like in col c?

=datediff("h",initial_measurement, second_measurement)<=4 OR datediff("h",initial_measurement, second_measurement)>=2
?

Thanks

 

[Mr. B]

Try using the DateDif in a new column in the query to that it returns the value from the calculation. Then set the criteria for this column to only show those that you need to see.