Formula Of IF Time Less than 30 minutes Met Or Not Met

[Lukma]

Hi Friends

Please need assistance with a Formula in Column E with Met or Not Met

I have In Column D with Duration Time Hours and I have formatted some time to display a negative sign as well which means earlier

So IF Column D (Time) is Less than 30 Minutes or With Negative Time to display In Column E, Met,
and IF Column D is Greater Than 30 Minutes and upward display In Column E, Not Met

I have placed Examples of all I need formulas for in Column E

Appreciate with help

Regards

OSMS-Onshore Jetty Operations vessels Tracking.xlsx
	A	B	C	D	E	F
2	Supply Vessel	Vessel Arrived Fairway Buoy Date&Time	Manifest Date & Time Passed	Duration Hours	Manifest passed Met / Not Met	Manifest Delay Hours
3	CECILIE-K	01/05/23 10:00	01/05/23 12:44	2:44	Met
4	Z-OCEAN	01/05/23 14:30	01/05/23 13:51	-0:39	Met
5	SWISSCO RUBY	02/05/23 06:00	01/05/23 22:40	-7:20	Met
6	LCT-SHEWELEH	01/05/23 16:00	01/05/23 18:27	2:27	Met
7	A-RANGER	01/05/23 20:00	01/05/23 17:00	-3:00	Met
8	ADNOC-S02	01/05/23 21:10	02/05/23 03:00	5:50	Not Met
9	ADNOC-810	01/05/23 01:50	01/05/23 20:08	18:18	Not Met
10	ADNOC-511	01/05/23 22:10	01/05/23 21:38	-0:32	Met
11	SK MAINSTAY	02/05/23 06:05	02/05/23 05:46	-0:19	Met
12	MUTAWA-402	01/05/23 10:00	02/05/23 01:50	15:50	Not Met
Sheet3

Cell Formulas
Range	Formula
D3:D12	D3	=IFERROR(IF((C3-B3)>0,(C3-B3),TEXT(ABS(C3-B3),"-h:mm")),"")

 

[pjmorris]

try this:

=IF(OR(LEFT(E2,1)="-",E2<1/48),"Met","Not Met")

Note that your rows 3, & 6 seem wrong.

HTH

 

[Lukma]

try this:

=IF(OR(LEFT(E2,1)="-",E2<1/48),"Met","Not Met")

Note that your rows 3, & 6 seem wrong.

HTH

Dear Pjmorris

many Thanks to you I will correct the noted error for 3 & 6

I appreciate your feedback and solution

Regards