CODEWITHSUNDEEP
excelexcel-formula
bd528
bd528

Reputation: 886

Excel checking for intersecting time

I'd like to know if it is possible to check if a time period (Column A is start, column B is end) falls between other certain time periods (rows 6 to 8).

enter image description here

Ideally, I'd like to return the values in column C

Upvotes: 1

Views: 71

Answers (1)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60199

Try:

=AND($B$1>A6,$A$1<B6)

enter image description here

Upvotes: 3

Related Questions