Here's the simplified situation
<tbody>
</tbody>
PROBLEM:
The countif returns only "1", this kinda puzzles me
I've tried applying *1440 to convert C2 and C3 into number of minutes (changed the Cell Formatting into General)
<tbody>
</tbody>PROBLEM:
The countif returns "0", err what?
Am I encountering some unknown limitation of countif here?
PURPOSE OF REFERRAL:
I am hoping to get the countif = 2 in the first situation
Many thanks in advance.
ADDITIONAL INFORMATION:
Using INT() in C2 and C3 after *1440 (situation 2) gives 14 and 15
A | B | C | D | |
1 | Time start | Time End | Duration | |
2 | 08:40 AM | 08:55 AM | 00:15 | =COUNTIF(C2:C3,"=0:15") |
3 | 04:20 PM | 04:35 PM | 00:15 |
<tbody>
</tbody>
PROBLEM:
The countif returns only "1", this kinda puzzles me
I've tried applying *1440 to convert C2 and C3 into number of minutes (changed the Cell Formatting into General)
A | B | C | D | |
1 | Time start | Time End | Duration | |
2 | 08:40 AM | 08:55 AM | 15 | =COUNTIF(C2:C3,"=15") |
3 | 04:20 PM | 04:35 PM | 15 |
<tbody>
</tbody>
The countif returns "0", err what?
Am I encountering some unknown limitation of countif here?
PURPOSE OF REFERRAL:
I am hoping to get the countif = 2 in the first situation
Many thanks in advance.
ADDITIONAL INFORMATION:
Using INT() in C2 and C3 after *1440 (situation 2) gives 14 and 15