Pass/Fail Formula

[MrsSurg]

Hi,

I am trying to have Column 'U' show pass or fail based on 3 columns showing a time difference.
If columns 'F', 'K' & 'R' are showing a difference greater that 30 minutes I would like column 'U' to show Fail. Anything below 30 minutes to show Pass.
Example in attached image.

Thank you!

 

[MrsSurg]

I have provided my suggestion in column N and if you adapted the post #3 suggestion as shown in column O you could also use that.
The column N formula would more easily scale up if you might end up with more groups of columns.

23 11 07.xlsm
	D	E	F	G	H	I	J	K	L	M	N	O
1	Timer	Data	Difference (mins)	Timer	Data	Difference (mins)	Yes/No	Timer	Data	Difference (mins)
2	6:55 AM	6:42 AM	0:13	2:18 PM	2:25 PM	-0:07		6:30 AM	6:28 AM	0:02	Pass	Pass
3	12:45 PM	1:10 PM	-0:25	11:10 PM	11:00 PM	0:10		6:37 PM	6:20 PM	0:17	Pass	Pass
4	8:33 PM	1:09 AM	19:24	7:29 AM	3:14 PM	-7:45		9:57 PM	10:42 PM	-0:45	Fail	Fail
5	6:57 AM	8:26 PM	-13:29	8:35 AM	10:01 AM	-1:26		2:31 PM	12:38 PM	1:53	Fail	Fail
6	10:04 PM	11:12 PM	-1:08	9:53 PM	8:00 AM	13:53		12:42 PM	11:46 AM	0:56	Fail	Fail
Pass Fail

Cell Formulas
Range	Formula
M2:M6,I2:I6,F2:F6	M2	=K2-L2
N2:N6	N2	=IF(MAX(ABS(IF(LEFT(D$1:M$1,2)="Di",D2:M2,0)))>30/1440,"Fail","Pass")
O2:O6	O2	=IF(OR(ABS(F2)>30/1440,ABS(I2)>30/1440,ABS(M2)>30/1440),"Fail","Pass")

That is wonderful and works a treat! Thank you for your help! Everyone here is so helpful =)

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.