Forum Discussion
Long Excel Nested formula
I have seen a formula (someone else wrote it) that can do some nifty nesting. I have the following cells data: a2 = 9:07, and b2 = 9:33 Cells d1:h1 are time intervals, 8:30, 9:00, 9:30, 10:00...
Hi Danny,
That could be like
=(E1>=$A$2)*(D1<=$B$2)*(MIN($B$2,E1)-MAX($A$2,D1))
and attached
- This worked perfectly! Thank you sir
