I'm trying to count the number of times a particular hour appears on my
spreadsheet. For example I have a spreadsheet listing dates and times. I
created an =MOD function to only display the time (hh:mm:ss, military time).
I would like to count the number of times a particular hour appears on the
spreadshe, ie how many times the hour "7", appears then "8" and so on and so
on until all hours are
acccounted for. I tried using =COUNTIF(B2:B520,"7*") for the the 7am hour,
but the results comes up as "0". Can anyone help with this. e