Formula help to get the exceeded hour from a target time

[Lukma]

Hi Guys

Can anyone assist with a formula to calculate only the exceeded hours from a target KPI Hours

I was told in my Office to use a formula for a KPI

Column C1 with arrive Date and Time
Column D3 with Manifest Passed 3 hours before vessel arrived FWB <=3 Hrs. in Column F3 =YES
Column G3 with Permission Date and Time <=6 Hrs.

What i need in column G3 is to get the Exceeded Hours ( Time ) only after subtracting the KPI 6 Hours from the Actual Time
IF E3 if Grater D3 KPI target Actual Is =10:29 then Subtract Actual from KPI 6Hrs = 4:29hrs.
So i need the formula that can give me the result of 4:29hrs in Column G3 and if it meet it should give Option a negative Time or to Leave Blank in cell

Regards

ILSP Summary Data Reports.xlsx
	C	D	E	F	G
2	FWB Date & Time	Manifest Date & Time	ADNOC Permission	Manifest Passed on Time KPI <=3 Hrs before Vessel arrive FWB	Permission Granted KPI <= 6 Hrs
3	31/12/20 21:00	31/12/20 11:05	31/12/20 21:34	YES
4	31/12/20 21:00	31/12/20 23:00	31/12/21 23:05	NO
5	01/03/21 05:00	01/03/21 06:00	01/03/21 05:10	NO
Sheet1

Cell Formulas
Range	Formula
F3:F5	F3	=IF(D3>C3-TIME(3,0,0),"NO","YES")

 

[arthurbr]

Are your dates real dates ( right aligned without manual alignment) ?

 

[Lukma]

Are your dates real dates ( right aligned without manual alignment) ?

Hi Arthurbr

Yes My dates are real aligned and manually aligned
i only Picked few entry from my data to show what i required
Regards