Hour Count

[EliA]

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

 

[Peo Sjoblom]

Try

=SUMPRODUCT(--(HOUR(B2:B250)=7))


--


Regards,


Peo Sjoblom

 

[Mike H]

Hi

=COUNT(IF(HOUR(B2:B520)=7,B2:B520,FALSE))

Which is an array so commit with
Ctrl+Shift+Enter

Mike

 

[EliA]

Thanks alot. That worked!!!

Try

=SUMPRODUCT(--(HOUR(B2:B250)=7))


--


Regards,


Peo Sjoblom

 

[Teethless mama]

=SUM(COUNTIF(A:A,{">=7:00",">8:00"})*{1,-1})