if with or condition

[Hassan]

Dear All,

i have the series of time in coloumn. I want to sum only that times duration
which are less then 10 min. or more then 5 min. all other will be count as
zero.

Thanks & regards

 

[Sandy Mann]

Try:

=SUMIF(A1:A30,">="&TIME(0,5,))-SUMIF(A1:A30,">"&TIME(0,10,))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Mike H]

Try this

=SUMIF(A1:A19,">"&TIME(0,5,0))-SUMIF(A1:A19,">"&TIME(0,10,0))

Mike
Bothe formatted correctly as time

Mike

 

[Sandy Mann]

which are less then 10 min. or more then 5 min.

If you mean both including both 5 min and 10 min thenb use the formula I
posted.

If you mean not including either 5 min ot 10 min then use Mike's formula.

Or if you want to include both 5 min but not 10 min in the addition use:

=SUMIF(A1:A30,">="&TIME(0,5,))-SUMIF(A1:A30,">="&TIME(0,10,))


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[Teethless mama]

=SUM(SUMIF(A:A,{">0:05:00",">=0:10:00"})*{1,-1})

 

[Dave]

Hi TM,
I didn't know you could give multiple criteria to SUMIF (and COUNTIF, I
discovered). XL seems to deal with your formula as an array formula, but
doesn't need to be array entered.
Always learning.
Regards - Dave.