Results 1 to 4 of 4

Sumproduct with Time Duration calculation

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2007
    Location
    Lombard, Illinois
    Posts
    60

    Sumproduct with Time Duration calculation

    Hi All,

    I'm using a sumproduct formula with multiple conditions to count the number of rows. I'm having trouble with a time duration calculation.

    At first I was trying to calulate the duration in the subproduct like this. But I get an error #value
    =SUMPRODUCT(--('Query Data'!$B$2:$B$1000="NOC Incident"),--(('Query Data'!$G$2:$G$1000-'Query Data'!$F$2:$F$1000)>"00:10:10"))

    Then I tried calculating the duration in a separate column and testing that column, but all I get is 0
    =SUMPRODUCT(--('Query Data'!$B$2:$B$1000="NOC Incident"),--('Query Data'!$O$2:$O$1000>"00:59:59"))
    I've formatted the field as time 37:30:50

    I'm trying to count the rows where the duration is greater than 1 hour.
    Attached Files Attached Files

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