Counting time ranges

[Guest]

I have a spreadsheet that looks like this...
07:51:4
07:56:2
07:59:5
08:36:0
08:36:2
09:04:2
09:08:1
09:12:2
09:13:3
09:15:4
09:17:3
09:17:3
09:20:1
09:23:1
09:24:1
I need to be able to count how many times each hour shows up, I tried using count if but the range isnt working?
Please help!!!

Cathy

 

[Frank Kabel]

Hi
maybe something like
=SUMPRODUCT(--(A1:a100>=9/24),--(A1:A100<10/24))
to count the numer of 9 hour occurences

-----Original Message-----
I have a spreadsheet that looks like this....
07:51:40
07:56:27
07:59:59
08:36:01
08:36:24
09:04:25
09:08:18
09:12:22
09:13:31
09:15:41
09:17:30
09:17:37
09:20:10
09:23:15
09:24:15
I need to be able to count how many times each hour shows

up, I tried using count if but the range isnt working?!

 

[Nikos Yannacopoulos]

Cathy,

You can use function Hour() on your data in the next available column to
return just the hour part, and then do SubTotals (function Count) on it to
count.

HTH,
Nikos

I have a spreadsheet that looks like this....
07:51:40
07:56:27
07:59:59
08:36:01
08:36:24
09:04:25
09:08:18
09:12:22
09:13:31
09:15:41
09:17:30
09:17:37
09:20:10
09:23:15
09:24:15
I need to be able to count how many times each hour shows up, I tried

using count if but the range isnt working?!

 

[Nikos Yannacopoulos]

Cathy,

You can use function Hour() on your data in the next available column to
return just the hour part, and then do SubTotals (function Count) on it to
count.

HTH,
Nikos

I have a spreadsheet that looks like this....
07:51:40
07:56:27
07:59:59
08:36:01
08:36:24
09:04:25
09:08:18
09:12:22
09:13:31
09:15:41
09:17:30
09:17:37
09:20:10
09:23:15
09:24:15
I need to be able to count how many times each hour shows up, I tried

using count if but the range isnt working?!