View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Johnny Mick[_2_] Johnny Mick[_2_] is offline
external usenet poster
 
Posts: 11
Default need help with 'counting' between values

Good afternoon,

I believe I have a simple task at hand, I just cannot come up with a way to
programmatically achieve the desired results. I have a column that has time
values displayed. I need to count (and display in cell c118) all of those
times that are between 8:00 and 8:59. Then count (and display in cell c119)
all of those times that are between 9:00 and 10:00; and so on, until probably
20:00.

I am a rookie, so I failed at trying to use an array to accomplish. I ended
up with 10 'For' loops, and even then it still didn't work the way it was
supposed to . Any and all assistance would be greatly appreciated. Thanks.