Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Occurences According to Time
I am trying to write a function that will count up the number of times an
occurence happens according to how long something took. Basically I have a column that subtracts how long a phone call took, it subtracts time B from time A to get a certain number of hours and minutes and that column is formatted to display 00:00 (hh:mm). I need a function that counts how many calls took < 20min, 20-30min, 30-60min, 60-120min, & 120min. I have gotten the function to work just looking at one cell, but when I give it the range of cells in that column I get an error. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Occurences According to Time
=COUNTIF(C1:C100,"<"&TIME(0,20,0))
=COUNTIF(C1:C100,"<"&TIME(0,30,0))-COUNTIF(C1:C100,"<"&TIME(0,20,0)) etc. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "SWFisherman" wrote in message ... I am trying to write a function that will count up the number of times an occurence happens according to how long something took. Basically I have a column that subtracts how long a phone call took, it subtracts time B from time A to get a certain number of hours and minutes and that column is formatted to display 00:00 (hh:mm). I need a function that counts how many calls took < 20min, 20-30min, 30-60min, 60-120min, & 120min. I have gotten the function to work just looking at one cell, but when I give it the range of cells in that column I get an error. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting Occurences According to Time
Thanks a lot, it works Perfect, your the man.
"Bob Phillips" wrote: =COUNTIF(C1:C100,"<"&TIME(0,20,0)) =COUNTIF(C1:C100,"<"&TIME(0,30,0))-COUNTIF(C1:C100,"<"&TIME(0,20,0)) etc. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "SWFisherman" wrote in message ... I am trying to write a function that will count up the number of times an occurence happens according to how long something took. Basically I have a column that subtracts how long a phone call took, it subtracts time B from time A to get a certain number of hours and minutes and that column is formatted to display 00:00 (hh:mm). I need a function that counts how many calls took < 20min, 20-30min, 30-60min, 60-120min, & 120min. I have gotten the function to work just looking at one cell, but when I give it the range of cells in that column I get an error. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting occurences of time it takes to calculate to 0 or just ove | New Users to Excel | |||
Counting occurences of a name | Excel Worksheet Functions | |||
Counting Occurences | Excel Programming | |||
Counting Occurences | Excel Discussion (Misc queries) | |||
Help on counting occurences | Excel Programming |