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.
|