Pass / Fail using Time

[lani_berina]

Anyone can help on how to calculate Column D:

A	B	C	D
13:00	14:00	01:00	Failed
13:00	13:00	00:30	Passed

<tbody>
</tbody>

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.