Counting specific date and time combined

  • Thread starter Thread starter jacesimon
  • Start date Start date
J

jacesimon

I have a spreadsheet design that I am working on that deals with
specific times to complete tasks. I need to be able to count the tasks
that I have completed in the same day or at least be able to count it
between certain time and certain dates, Really I just need it to count
for the same day and between certain times to calculate a count to
know how many issues got solved in the day. If anyone can help me that
would be great.
 
Your list of dates and times is in A2:A6. This looks for 6/25/2007 between
noon and midnight.

There may be an easier way than this, but right now, I can't think of it.

=SUMPRODUCT(--(YEAR(A2:A6)=2007),--(MONTH(A2:A6)=6),--(DAY(A2:A6)=25),--(HOUR(A2:A6)<24),--(HOUR(A2:A6)>12))

HTH,
Barb Reinhardt
 
Back
Top