Results 1 to 8 of 8

Countif of Hours and Mins not dates

Threaded View

  1. #1
    Registered User
    Join Date
    11-16-2008
    Location
    Dubai
    Posts
    73

    Countif of Hours and Mins not dates

    Afternoon all

    I have a data feed that gives a column of cells formated mm/dd/yy hh:mm
    These are call entries, what i want to do is count all the occurances each hour, so count all the entries say between 9am and 10am. However the column is very long and holds data for many weeks so i want to be able to ignore the date part of the cell.

    For example

    3/17/09 9:58
    3/18/09 10:58
    3/18/09 8:58
    3/19/09 8:58
    3/19/09 9:58
    3/19/09 9:58

    So the entries between 9 and 10 are = 3

    Ideally i do not want to do text to colums and split out the parts. i would like to leave the source data alone.

    Nick
    Last edited by Nick_in_Dubai; 03-17-2009 at 08:51 AM.

Thread Information

Users Browsing this Thread

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

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