Results 1 to 6 of 6

get a count depending on the interval

Threaded View

  1. #1
    Registered User
    Join Date
    01-10-2013
    Location
    Sydney
    MS-Off Ver
    Excel 2007
    Posts
    37

    get a count depending on the interval

    HI,i have a spreadsheet with time intervals. What i'd like to do is get a count depending on the interval.

    I not sure which function to use. I have 0 to 24 hours, 24:01 to 48 hours, and 48:01 to 72 hours and 72:01 hours or more.

    The data is on sheet1 column F. The count of the different time intervals goes in to sheet2 B2 for 0 to 24 hours, C2 for 24:01 to 48 hours, D2 for 48:01 to 72 hrs, E2 for over 72 hours.

    Thanks
    Last edited by FDibbins; 01-19-2014 at 07:53 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. index function error using match function to get data from a cell in an array
    By mabildgaard in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-17-2013, 02:21 AM
  2. [SOLVED] IF Function referencing IsNumber, Match, Left function on separate sheets
    By Touch9713 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-12-2013, 10:09 PM
  3. Replies: 1
    Last Post: 03-21-2012, 11:22 AM
  4. Replies: 2
    Last Post: 03-20-2009, 01:29 PM
  5. Excel - User Defined Function Error: This function takes no argume
    By BruceInCalgary in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-18-2006, 04:05 PM

Tags for this Thread

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