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.
Bookmarks