+ Reply to Thread
Results 1 to 1 of 1

Excel 2000 Count Entries within a time frame.

  1. #1
    Registered User
    Join Date
    04-10-2014
    Location
    Fresno, CA
    MS-Off Ver
    Excel 2000
    Posts
    1

    Excel 2000 Count Entries within a time frame.

    Good Afternoon, am currently working on a project and was able to build sheet successfully on Excel 2010. However my Work PC has 2000. So here is the issue:

    I have =NOW() on cell E2 then I subtracted a minute from that on Cell E3 by using =(((E2*24*60)-1)/60/24). B:B has time slots that are entered every time the X key is pressed (I have a keyboard encoder connected to a Sensor that triggers a key stroke every time something passes through the sensor). So B:B is formatted to have Time X:XX:XX PM/AM. So what am trying to accomplish is, I want a formula that will give me Number of entries entered between E2 and E3. Basically capture every time slot that falls between. Thanks, hope I made sense.

    Here's the formula I had on Office 2010
    =COUNTIFS(B:B,">="&E3,B:B,"<="&now)

    I found this formula useful and it worked for me
    =SUM(COUNTIF(B:B,"<="&E2)+SUM(COUNTIF(B:B,">="&E3)))/2
    Last edited by Daniel Salinas; 04-15-2014 at 05:25 PM. Reason: Solved

+ 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. Identify and count overlapping date/time entries on a call log
    By Andrew989 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-23-2012, 12:24 PM
  2. Excel 2007 Horizontal Bar Chart with fixed time frame
    By chartnovice in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-19-2012, 01:16 PM
  3. [SOLVED] Remove duplicate entries based on unique number Excel 2000
    By IM22 in forum Excel General
    Replies: 7
    Last Post: 04-09-2012, 01:56 PM
  4. Count time (entries per hour)
    By canonelan2 in forum Excel General
    Replies: 6
    Last Post: 10-07-2008, 03:23 PM
  5. Prevent duplicate entries in Excel 2000
    By Stressed in forum Excel General
    Replies: 10
    Last Post: 01-18-2006, 04:10 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