Results 1 to 4 of 4

COUNTIFS - Time Issue

Threaded View

  1. #1
    Registered User
    Join Date
    01-23-2013
    Location
    Southern California
    MS-Off Ver
    Excel 2010
    Posts
    2

    COUNTIFS - Time Issue

    See screenshot here (http://i.imgur.com/Ck6oBuZ.png)

    I'm trying to calculate the amount of arrivals that occurred between 10am and 10:59pm.
    To calculate this i'm using countifs(arrivaltimerange, >=10am, arrivaltimerange, <11am)

    The issue I ran into is the times are taken from the Arrival Date Time column. I use MOD(Arrivaldatetimecolumn, 1) which outputs just the time into the Arrival Time column.
    For some odd reason the countifs function will not count 10:00am's. But if I type in 10:00am into the exact same cell as the one outputting 10:00 am through MOD, it will then see the 10AM and add it to the count.

    It's very very bizarre since it ONLY happens on the ">=time" times and is directly related to MOD.

    Any help would be appreciated.

    Thanks

    -- Edit
    Even MORE bizarre.
    If I do the countifs search for 10:30am it will correctly produce the result of 3.
    Last edited by kjcdude; 01-23-2013 at 10:27 PM.

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