Counting specific date and time combined

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jacesimon@yahoo.com - 26 Jun 2007 02:13 GMT

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.

Reply to this Message

Barb Reinhardt - 26 Jun 2007 02:35 GMT

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

> 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
[quoted text clipped - 3 lines]
> know how many issues got solved in the day. If anyone can help me that
> would be great.

Reply to this Message

Rate this thread: