Sunday, August 17, 2014

yogi_For Non-Uniform Time Entries In Column L Count Instances Of Specified Hour Using 24 Hour Clock

                        Google Spreadsheet   Post  #1730
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Aug-14-2014
post by Samuel O'Brien:
Counting a time range (i.e. any time that starts with "7"
I want to count a set of data that has non-uniform entries for times. 

I have a data set with a range of times entered by users. (i.e. 7:45AM, 7:30, 7:45-8) and I want to specifically count the number of entries that start with a 7. (i.e. any times that start with a "7") I have tried =countif(L2:L9; "7*") 
but it doesn't give accurate counts. 

Any help?