software

Using Excell 2000, I have a column with time as a 4 digit number from a 24
hour clock and I need to count all the times into their respective hour cells
- eg: 1315 hrs needs to be counted in the 1300 to 1359 hrs cell. I have tried
Countif quot;gt; 1259 and lt; 1400quot; but always get O, irrespective of how many 4
digits numbers I put that fall into that 1259 -gt; 1300 catergory. As a bit of
a novice with Excel, I suspect I'm looking for a quot;way too easy solutionquot; to
my formula and will probably have to get much more technical.
Any suggestions greatly and gratefully accepted as this one has had my head
scratched for a while now. Thank you for your gt; time so that I can use lt; of
mine.

Thank you very much for your most helpful reply Bruce ... I have tried your
suggested formula and it works very successfully. Excellent advise, well
done, and thank you very much once again.
Stu Lesliequot;bpeltzerquot; wrote:

gt; Try combining two countif functions, one to count all entries gt;= 1300, and
gt; another to count all those gt;=1400. Your answer is the difference between the
gt; two:
gt; =countif(range,quot;gt;=1300quot;)-counitf(range,quot;gt;=1400quot;)
gt; --Bruce
gt;
gt; quot;Stu Lesliequot; wrote:
gt;
gt; gt; Using Excell 2000, I have a column with time as a 4 digit number from a 24
gt; gt; hour clock and I need to count all the times into their respective hour cells
gt; gt; - eg: 1315 hrs needs to be counted in the 1300 to 1359 hrs cell. I have tried
gt; gt; Countif quot;gt; 1259 and lt; 1400quot; but always get O, irrespective of how many 4
gt; gt; digits numbers I put that fall into that 1259 -gt; 1300 catergory. As a bit of
gt; gt; a novice with Excel, I suspect I'm looking for a quot;way too easy solutionquot; to
gt; gt; my formula and will probably have to get much more technical.
gt; gt; Any suggestions greatly and gratefully accepted as this one has had my head
gt; gt; scratched for a while now. Thank you for your gt; time so that I can use lt; of
gt; gt; mine.