- Sep 17, 2002
Hello again, I'm full of questions today! I have a sheet that lists hours in column A in half hour increments starting at 0:00. So, A2 is 0:00, A3 is 0:30...etc. Column B through V are dates. Column B1 is 11/01/02, B3 is 11/02/02...etc. The number of calls received in that half hour time go from cell B2:V49. What I'd like to do...is have a cell I can type a start time in, and a cell I can type an end time in, and have it return the # of calls received between those two times for the entire month. For instance in cell AA2 I would type: 08:30, and in cell AA3, I would type 17:30. It should return the sum of calls received for the whole month between those 2 times and put that number is say...cell AB2.