ChetShannon
Board Regular
- Joined
- Jul 27, 2007
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
I have a question about time, calculated time and if statements. I have set A of data that starts with a constant time say 3:00 in the first cell and going downward vertically I add "00:01" to the first cell and this continues going further down in set A getting higher in time in a calculated fashion. I have another set B which is actual constant time values (not a formula) in format hh:mm. My problem / question is when I perform logical IF statements on set A and set B where two cells are visibly equal the IF statement is coming up as false even though both times are viewed as equal.
Why might this be?
Example below:
Set A=== Set B=== Set C===
3:00 A1 a constant 2:00 = B1 100
3:01 A2=A1+"00:01" 2:30 = B2 95
3:02 A3=A2+"00:01" 3:01 = B3 50
3:03 A4=A3+"00:01" 3:09 = B4 45
Then when I logically compare A2 with B3 I get a FALSE. Why is that? It seems that the answer should be TRUE. I am trying to bring the values of C into a target column D (not shown) where the value in set A corresponds to the item in set B. In other words D2 would have a value of 50 because A2 = B3.
Thanks,
Chet
Why might this be?
Example below:
Set A=== Set B=== Set C===
3:00 A1 a constant 2:00 = B1 100
3:01 A2=A1+"00:01" 2:30 = B2 95
3:02 A3=A2+"00:01" 3:01 = B3 50
3:03 A4=A3+"00:01" 3:09 = B4 45
Then when I logically compare A2 with B3 I get a FALSE. Why is that? It seems that the answer should be TRUE. I am trying to bring the values of C into a target column D (not shown) where the value in set A corresponds to the item in set B. In other words D2 would have a value of 50 because A2 = B3.
Thanks,
Chet