software

I am using the following to count the number of times a time period occurs.
I would like to ask someone to show me how I can write this to count the
number of time occurances that happen which are 3 min and higher.

Thanks

=IF(ISERROR(SUMPRODUCT((daily_CS_Ticket_Per!F1:F10 00=quot;0 hr. 00
min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 01
min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 02 min.quot;))),quot;-quot;,
(SUMPRODUCT((daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 00
min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 01
min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 02 min.quot;))))Use form =SUMPRODUCT(--(F1:A1000gt;=TIME(0,3,0)))

General note: it would be much simpler if Sheet names could be omitted or
reduced to Sheet1 in examples- easier to read.

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;JRquot; gt; wrote in message
...
gt;I am using the following to count the number of times a time period occurs.
gt; I would like to ask someone to show me how I can write this to count the
gt; number of time occurances that happen which are 3 min and higher.
gt;
gt; Thanks
gt;
gt; =IF(ISERROR(SUMPRODUCT((daily_CS_Ticket_Per!F1:F10 00=quot;0 hr. 00
gt; min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 01
gt; min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 02 min.quot;))),quot;-quot;,
gt; (SUMPRODUCT((daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 00
gt; min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 01
gt; min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 02 min.quot;))))
gt;
Alternatively =COUNTIF(F1:A1000,quot;gt;=quot;amp;TIME(0,3,0))

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;JRquot; gt; wrote in message
...
gt;I am using the following to count the number of times a time period occurs.
gt; I would like to ask someone to show me how I can write this to count the
gt; number of time occurances that happen which are 3 min and higher.
gt;
gt; Thanks
gt;
gt; =IF(ISERROR(SUMPRODUCT((daily_CS_Ticket_Per!F1:F10 00=quot;0 hr. 00
gt; min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 01
gt; min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 02 min.quot;))),quot;-quot;,
gt; (SUMPRODUCT((daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 00
gt; min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 01
gt; min.quot;) (daily_CS_Ticket_Per!F1:F1000=quot;0 hr. 02 min.quot;))))
gt;