Results 1 to 5 of 5

Count occurrences and sum values with times spanning over midnight.

Threaded View

  1. #1
    Registered User
    Join Date
    01-22-2011
    Location
    Sweden
    MS-Off Ver
    Excel 2007
    Posts
    5

    Count occurrences and sum values with times spanning over midnight.

    I am trying to count Count occurrences between two times spanning over midnight. It all works as long as the time not goes over 00:00. This is what I have

    A=date and values in 2012-01-02 00:30:00 format
    B=Value in 10/20/30 This is some thing I will deal with after i have figured out my occurrences problem

    This is what I have come up with =PRODUKTSUMMA(--(TIMME(A2:A50)>=7);(--(TIMME(A2:A50)<=23)))
    But this only works when not the time is between say start time:23:23 too 05:45 and it can not specify down two minutes criteria. Any help would be greatly appreciated
    Attached Files Attached Files
    Last edited by SorZer; 12-11-2012 at 07:13 AM.

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