if with or condition
 

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

if with or condition
 

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


Replace @mailinator.com with @tiscali.co.uk


"Hassan" wrote in message
...
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

if with or condition
 

Try this

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

Mike
Bothe formatted correctly as time

Mike

"Hassan" wrote:

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

if with or condition
 

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


Replace @mailinator.com with @tiscali.co.uk


"Sandy Mann" wrote in message
...
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


Replace @mailinator.com with @tiscali.co.uk


"Hassan" wrote in message
...
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

if with or condition
 

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


"Hassan" wrote:

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

if with or condition
 

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.