ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Conditional Testing Glitch (https://www.excelbanter.com/excel-programming/395152-conditional-testing-glitch.html)

Arturo

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

John Bundy

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


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