Counting time ranges

C

Cathy

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
 
F

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
Click to expand...
up, I tried using count if but the range isnt working?!
 
N

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

Cathy said:
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
Click to expand...
using count if but the range isnt working?!
 
N

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

Cathy said:
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
Click to expand...
using count if but the range isnt working?!
 
Top