Results 1 to 4 of 4

Countif between time ranges

Threaded View

dreicer_Jarr Countif between time ranges 10-14-2008, 06:46 PM
shg I can't tell what you're... 10-14-2008, 07:33 PM
dreicer_Jarr Countif between time/dates 10-14-2008, 07:59 PM
shg In B14 and copy down and... 10-14-2008, 10:47 PM
  1. #1
    Forum Contributor
    Join Date
    04-02-2008
    Location
    Jacksonville Beach, Florida
    MS-Off Ver
    Microsoft Excel 2003 and 2010
    Posts
    264

    Countif between time ranges

    How would I count the number of times a range was above/below a certain number within certain time ranges?

    So I have my time ranges and "data" and I want to know how many times for each hour (12, 1 pm, 2 pm etc.) the "data" or time in minutes was say greater than 30? See attachment for clarity...
    Attached Files Attached Files
    Last edited by dreicer_Jarr; 10-14-2008 at 07:09 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. COUNTIF in non contiguous cell ranges
    By barrycarney in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-23-2008, 02:38 PM
  2. total time
    By telcotech in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-02-2008, 10:44 PM
  3. Time Ranges
    By jmag in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-17-2008, 03:24 PM
  4. countif on nonconnected ranges
    By village_idiot in forum Excel General
    Replies: 17
    Last Post: 05-15-2007, 06:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1