RE: Counting time ranges
From: Mark Graesser (anonymous_at_discussions.microsoft.com)
Date: 05/05/04
- Next message: Steve: "But what if..."
- Previous message: Shayan: "How do I reference a file that does not exist yet"
- In reply to: Cathy: "Counting time ranges"
- Next in thread: Nikos Yannacopoulos: "Re: Counting time ranges"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 5 May 2004 07:31:12 -0700
Hi Cathy,
You can put Frank's and Nikos' suggestions together to get the formula:
=SUMPRODUCT(--(HOUR(A1:A15)=B1))
Where A1:A15 is the range of time values, and B1 is the hour.
Good Luck,
Mark Graesser
mark_graesser@yahoo.com
Boston MA
----- Cathy wrote: -----
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?!
Please help!!!!
Cathy
- Next message: Steve: "But what if..."
- Previous message: Shayan: "How do I reference a file that does not exist yet"
- In reply to: Cathy: "Counting time ranges"
- Next in thread: Nikos Yannacopoulos: "Re: Counting time ranges"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
