Greater Than or Less Than

  • Thread starter Thread starter Reuben
  • Start date Start date
R

Reuben

I am setting up a work sheet based on events that happened
through out the day, such as power outages. Breaking it
down into 6 sections of the day.
12:00 AM - 4:00 AM
4:00 AM - 8:00 AM
8:00 AM - 12:00 PM
12:00 PM - 4:30 PM
4:30 PM - 8:30 PM
8:30 PM - 12:00 AM

There have been over 38 occurrences during the last year
and I would like to count depending on what time of the
day the event happened. I have been trying to use countif
with my range and then "<8:00AM"&">4:00AM" with little
luck. Any help or suggestions would be appreciated.
 
Reuben,

DFon't know how you intend to handle outages that cross sections, but this
formula may be of help

=SUMPRODUCT((A1:A1000>TIME(4,0,0))*(B1:B1000<TIME(8,0,0)))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top