Counting Occurances of Time

E

EliA

I'm trying to count the number of times a particular hour appears on my
spreadsheet. For example I have a lists of times ranging from 7am to 9pm
(hh:mm:ss, military time) and would like a breakdown of howmay rows I have
containing the hour of "7", then "8" and so on until all hours are
acccounted. Can you help
 
K

Klatuu

"Counting Occurances of Time"

As few as we insignificant creatures here on Earth know, time has occured
only once. <g>
This is an Excel question and you may get a better answer there, but I might
suggest you look at the CountIf function.

Have a good .......time.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Hour Count 4
military time calculations 1
Count occurances of a name over previous 12 months 4
Time formula help needed 2
Count occurances in a range. 5
Using COUNT for text occurances in unusual worksheet? 4
Format a TIME image in a cell 3
Help on Counting Query 4

Top