![]() |
Conditional Testing Glitch
I have two start / stop day ranges associated with variables.
1st day range: bVa = 83 (start) bVb = 116 (stop) 2nd day range: tVa = 151 (start) tVb = 181 (stop) Im trying to test for overlap between the first and second day range and if that overlap is greater than say 7 then I have in place what should happen. Currently Im just trying to just meet the simpler condition; is there overlap between the two day ranges but am stuck in thought and diagram€¦ Appreciatively, Arturo |
Conditional Testing Glitch
Not positive I understand the problem, but it looks like you just want to
find out if the second days range falls into the first days range. If that is true then overlap can be checked by subtracting tVa-bVb. this will tell you what is between the end of the first day and the start of another. In your case the answer is 35, if it is ever <0 then you have overlap, if you want to check for say 7 digits of overlap its just if it is <=-7. Hope that is what you needed. -- -John Please rate when your question is answered to help us and others know what is helpful. "Arturo" wrote: I have two start / stop day ranges associated with variables. 1st day range: bVa = 83 (start) bVb = 116 (stop) 2nd day range: tVa = 151 (start) tVb = 181 (stop) Im trying to test for overlap between the first and second day range and if that overlap is greater than say 7 then I have in place what should happen. Currently Im just trying to just meet the simpler condition; is there overlap between the two day ranges but am stuck in thought and diagram€¦ Appreciatively, Arturo |
Conditional Testing Glitch
This didn't hit it it exactly - my bad for not articulating the glitch
clearly... "John Bundy" wrote: Not positive I understand the problem, but it looks like you just want to find out if the second days range falls into the first days range. If that is true then overlap can be checked by subtracting tVa-bVb. this will tell you what is between the end of the first day and the start of another. In your case the answer is 35, if it is ever <0 then you have overlap, if you want to check for say 7 digits of overlap its just if it is <=-7. Hope that is what you needed. -- -John Please rate when your question is answered to help us and others know what is helpful. "Arturo" wrote: I have two start / stop day ranges associated with variables. 1st day range: bVa = 83 (start) bVb = 116 (stop) 2nd day range: tVa = 151 (start) tVb = 181 (stop) Im trying to test for overlap between the first and second day range and if that overlap is greater than say 7 then I have in place what should happen. Currently Im just trying to just meet the simpler condition; is there overlap between the two day ranges but am stuck in thought and diagram€¦ Appreciatively, Arturo |
All times are GMT +1. The time now is 07:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com