+ Reply to Thread
Results 1 to 5 of 5

How to get a count of timestamp on 1 date

  1. #1
    Registered User
    Join Date
    04-13-2011
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    3

    How to get a count of timestamp on 1 date

    I have a tstamp column, looks like what I pasted below. How do I write a formula that will give me the total count of tstamp for say 4/1/2011? I want a total count of all the tstamp entries that have 4/1/2011.

    TSTAMP
    4/1/2011 14:47
    4/1/2011 15:14
    4/1/2011 15:15
    4/1/2011 15:16
    4/1/2011 15:17
    4/1/2011 15:18
    4/1/2011 15:18
    4/1/2011 15:37
    4/4/2011 13:32
    4/4/2011 9:31
    4/4/2011 9:30
    4/4/2011 9:33
    4/4/2011 13:32
    4/4/2011 13:35
    4/7/2011 9:23
    4/7/2011 9:26
    4/7/2011 9:27
    4/7/2011 9:22
    4/7/2011 9:31
    4/8/2011 13:42
    4/8/2011 11:01
    Last edited by macking; 04-13-2011 at 01:54 PM.

  2. #2
    Registered User
    Join Date
    04-12-2011
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: How to get a count of timestamp on 1 date

    Hi Macking

    Probably an easier way than this but here goes, if your data is in column A then in Column B use, =INT(A1) and fill down. You can then do your countif off this so =COUNTIF(B:B,$C$1) if you put the value you want to search in a cell C1.

    Thanks

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: How to get a count of timestamp on 1 date

    Try this
    Please Login or Register  to view this content.

    Select from the drop-down in the yellow cell to change the results

    Hope this helps

    [EDIT]
    Added COUNTIFS to the attachment.
    Attached Files Attached Files
    Last edited by Marcol; 04-13-2011 at 12:58 PM. Reason: 2007 and above solution added to attachment
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  4. #4
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,578

    Re: How to get a count of timestamp on 1 date

    OR
    =SUMPRODUCT(--(INT($A$1:$A$500)=C1))
    where C1 contains your date
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  5. #5
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: How to get a count of timestamp on 1 date

    Or given OP uses 2010
    Please Login or Register  to view this content.
    I have added this to the above attachment

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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