MINUTE’s calculation

[hsandeep]

I am looking for formula (in a cell F2) to get difference in MINUTES from D2 (system’s time being regularly getting updated) & B2 with a limit in C2

F2=0 IF
EITHER D2 < B2
OR D2 > C2


How to accomplish?
Thanks in advance
I am using Excel 2007
Sheet1

	B	C	D	E	F

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 104px"><col style="WIDTH: 104px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
[TD="bgcolor: #cacaca, align: center"]2[/TD]
[TD="align: right"]10:30:00[/TD]
[TD="align: right"]11:00:00[/TD]
[TD="align: right"]10:36:18[/TD]

[TD="bgcolor: #ffff00, align: right"]6[/TD]

</tbody>

 

[DanteAmor]

Could be.


=SI(D2 > B2,D2-B2,B2-D2)

But what relationship does cell C2 have?
You could give more examples and the expected results.

 

[hsandeep]

Could be.


=SI(D2 > B2,D2-B2,B2-D2) formula is not clear

But what relationship does cell C2 have?
You could give more examples and the expected results.

C2=It is maximum time after which F2 should become 0

 

[DanteAmor]

Try this

=IF(OR(D2 < B2,D2 > C2),0,D2-B2)

 

[hsandeep]

Try this

=IF(OR(D2 < B2,D2 > C2),0,D2-B2)

It gives [TABLE="width: 93"]
<tbody>[TR]
[TD="class: xl64, width: 93, align: right"]12:06:18 AM I need ONLY 6


[/TD]
[/TR]
</tbody>[/TABLE]

 

[hsandeep]

From my original post F2 has to fill value which shows that 6 minutes have passed since 10:30:00 & system's time is STILL BETWEEN B2 & C2

 

[DanteAmor]

Change the format of cell F2 to General

Try this please

=IF(OR(D2<B2,D2>C2),0,MINUTE(D2-B2))

 

[hsandeep]

Try this please

=IF(OR(D2<b2,d2>C2),0,MINUTE(D2-B2))[/QUOTE]
Thanks DanteAmor. IT WORKS.........I re-phrased the formula =IF(OR(D2>=C2,D2<B2),0,MINUTE(D2-B2)) with your help

</b2,d2>

 

[DanteAmor]

(Again with problems with the forum editor, delete the formulas)

=IF(OR(D2<B2,D2>C2),0,MINUTE(D2-B2)) <tbody> </tbody>

<tbody>
</tbody>