Pass / Fail using Time

[lani_berina]

Anyone can help on how to calculate Column D:

[TABLE="width: 500"]
<tbody>[TR]
[TD="align: center"]A[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D[/TD]
[/TR]
[TR]
[TD]13:00[/TD]
[TD]14:00[/TD]
[TD]01:00[/TD]
[TD]Failed[/TD]
[/TR]
[TR]
[TD]13:00[/TD]
[TD]13:00[/TD]
[TD]00:30[/TD]
[TD]Passed[/TD]
[/TR]
</tbody>[/TABLE]

1. In column A and B, and C, i used MOD, format cells custom 00\:00 in subtracting time.
2. For column D, I tried this formula IF(C1>1,"PASS","FAIL") but it does not give me the exact answer.

I want the Result should be like this If more than one One Hour it should be Fail, IF less than one hour it should Pass.


Thank you.

Lani

 

[jtakw]

Hi,

Your sample results does Not match the logic of your attempted formula and does Not match your written description, so adjust the > in the below formula to >= if needed.

Also, don't know how you got 00:30 in C2.

Book1
	A	B	C	D
1	13:00	14:00	1:00	Pass
2	13:00	13:00	0:30	Pass
Sheet303

Cell Formulas
Range	Formula
D1	=IF(C1>1/24,"Fail","Pass")

 

[lani_berina]

thank you

 

[jtakw]

You're welcome.