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 " 1259 and < 1400" but always get O, irrespective of how many 4
digits numbers I put that fall into that 1259 - 1300 catergory. As a bit of
a novice with Excel, I suspect I'm looking for a "way too easy solution" 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 time so that I can use < 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 Leslie


"bpeltzer" wrote:

Try combining two countif functions, one to count all entries = 1300, and
another to count all those =1400. Your answer is the difference between the
two:
=countif(range,"=1300")-counitf(range,"=1400")
--Bruce

"Stu Leslie" wrote:

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 " 1259 and < 1400" but always get O, irrespective of how many 4
digits numbers I put that fall into that 1259 - 1300 catergory. As a bit of
a novice with Excel, I suspect I'm looking for a "way too easy solution" 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 time so that I can use < of
mine.