+ Reply to Thread
Results 1 to 2 of 2

COUNTIF that evaluates whether or not a time stamp is within a time range

  1. #1
    Registered User
    Join Date
    06-12-2013
    Location
    Rochester, Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    80

    COUNTIF that evaluates whether or not a time stamp is within a time range

    Hi Folks,

    I'm looking for a countif function that evaluates whether or not a Time stamp in Column B is within any date ranges created by a series of time stamps in column A

    Example:

    2/14/14 1:26 PM
    2/14/14 2:26 PM 2/14/14 1:30 PM 1
    2/14/14 3:26 PM 2/14/14 1:36 PM 1
    2/14/14 4:26 PM 2/14/14 4:24 PM 1
    2/14/14 5:26 PM 2/14/14 6:24 PM 0


    Any reply and input is greatly appreciated.
    Last edited by athyeh; 02-24-2014 at 01:43 PM.

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: COUNTIF that evaluates whether or not a time stamp is within a time range

    One way:
    c: =MIN(IF($A$1:$A$10>B2,1))
    Confirm Control+shift+enter
    Drag down
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 11-06-2012, 01:37 AM
  2. [SOLVED] Extract a time from a cell with date and time stamp and then perform calculations
    By Marcos Aristotelous in forum Excel General
    Replies: 3
    Last Post: 10-31-2012, 04:36 AM
  3. Replies: 3
    Last Post: 02-22-2011, 01:53 PM
  4. Date and Time Stamp for Last Activity in Range
    By XLevel in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-19-2011, 07:34 AM
  5. time stamp a cell that doesn,t change when time stamping another
    By RC in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-12-2005, 10:05 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