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     www.energyefficientbuild.com.   Aug-14-2014
post by Samuel O'Brien:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/BcjiAw_SDjk)
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?

Thanks!
Sam
---------------------------------------------------------------------------------------------------


No comments:

Post a Comment