crooser100
New Member
- Joined
- Dec 2, 2009
- Messages
- 16
Hi there <?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
I have a list of times that I want to collate. I need to count the no of occurrences:<o></o>
<o> </o>
Under 30 seconds<o></o>
Between 30 seconds to 1 minute<o></o>
Over 1 minute. <o></o>
<o></o>
However I’m unsure of the correct formula to use... I’ve tried using =COUNTIF(C13:C93,">0:00:30") but it keeps coming up with 0? Is this to do with the time? <o></o>
<o> </o>
Can anyone help? <o></o>
Regards
Jo
<o></o>
I have a list of times that I want to collate. I need to count the no of occurrences:<o></o>
<o> </o>
Under 30 seconds<o></o>
Between 30 seconds to 1 minute<o></o>
Over 1 minute. <o></o>
<o></o>
However I’m unsure of the correct formula to use... I’ve tried using =COUNTIF(C13:C93,">0:00:30") but it keeps coming up with 0? Is this to do with the time? <o></o>
<o> </o>
Can anyone help? <o></o>
Regards
Jo