if with or condition

  • Thread starter Thread starter Hassan
  • Start date Start date
H

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
 
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
 
Try this

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

Mike
Bothe formatted correctly as time

Mike
 
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
 
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.
 
Back
Top