Yeah!! That worked but i need to add in per day. I have a 30 day list of
hours and a row next to it that goes with the day. I need to break it out
that I have XX entires on the 1st for the 12-8 and XX entries on the 1st for
the 8-4 etc etc per day per shift

"Pete_UK" wrote:

You will need three formulae, like this:

=SUMPRODUCT(--(Sheet4!C2:C200=TIME(0,0,0)),--(Sheet4!
C2:C200<=TIME(8,0,0)Â*))

=SUMPRODUCT(--(Sheet4!C2:C200=TIME(8,0,0)),--(Sheet4!
C2:C200<=TIME(16,0,0)Â*))

=SUMPRODUCT(--(Sheet4!C2:C200=TIME(16,0,0)),--(Sheet4!
C2:C200<=TIME(23,59,59)Â*))

The first formula will count the shift between midnight and 8:00am,
the second between 8:00am and 4:00pm, and the third between 4:00pm and
midnight.

Hope this helps.

Pete

On Jan 30, 1:03 pm, Nycole wrote:
That has worked, but now I still need to break it down even further. I need
to know how many in an 8 hour shift per one day.



"Bob Phillips" wrote:
time_range is the cells to be tested so it is those that you must change.. I
also mentioned that time_range must be an explicit range it cannot be whole
columns.

The TIME statement was supplying the times to be checked against (8AM and
4PM in my example), so you should only adjust these parts if you want
different times, don't remove the TIME function.

In summary, your test should be

=SUMPRODUCT(--(Sheet4!C2:C200=TIME(8,0,0)),--(Sheet4!C2:C200<=TIME(16,0,0)Â*))

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Nycole" wrote in message
...
I am using the following and I am getting #NAME?

=SUMPRODUCT(--(time_range=Sheet4!C:C(8,0,0)),--(time_range<=Sheet4!C:C(16,Â*0,0)))

"Bob Phillips" wrote:

=SUMPRODUCT(--(time_range=TIME(8,0,0)),--(time_range<=TIME(16,0,0))

the time_range must be an explicit range it cannot be whole columns.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Nycole" wrote in message
...
I have a list of times 0:00 - 24:00 and days and I need to find out how
many
files were processed between in an 8 hour shift per day

Entry Number TIME Est. Date of Arrival
9065233-5 14:56 1/1/2008
9065234-3 15:11 1/1/2008
9065235-0 15:26 1/1/2008
9065240-0 16:02 1/1/2008
7082203-1 18:30 1/1/2008
9065245-9 1:01 1/2/2008
3705209-4 1:41 1/2/2008
3705220-1 3:05 1/2/2008- Hide quoted text -

- Show quoted text -