Populate Based On Time and Text

[kumara_faith]

Hi,

I have the following:

Excel Workbook
	B	C	D
3	Affected	Downtime	Y &>6M
4	Yes	4.28	No
Sheet1

The downtime cell is actually in time format which means 4 hours and 28 minutes. I need to flag in cell D4 as Yes if the downtime is more or equal to 6 minutes and the "Affected" is Yes.

Is there a way to amend the formula ?

Appreciate all the help.

 

[mole999]

six minutes is 0.00416666666666667 decimal

 

[kumara_faith]

mole999,

Thank you. That worked. Appreciate your reply.