Formula for time difference and deduct meak break

[redspanna]

Hi al

Can somebody help with a formula that will check the time difference between two times (in column E & G) and if under 6hrs then deduct 15mins time and if => 6hrs then deduct 30mins
I currently use this formula (in column I) to calculate the time and deduct 30mins regardless
=IF(ISBLANK(H357),"",IF(H357="N",G357-E357,8/24)-(1/48))

E	F	G	H	I
26/03/2020 07:15:00​		26/03/2020 13:14:00​	N​	05:29​

So with above example the correct result in column I should be 05:44 as the time difference is under 6hrs and only 15mins should be deducted. not 30


TIA

 

[Momentman]

In very simple terms, it would look like this

=IF(G1-E1<1/4,G1-E1-1/96,G1-E1-1/48)

, 1/4(6 hrs)

 

[redspanna]

In very simple terms, it would look like this

=IF(G1-E1<1/4,G1-E1-1/96,G1-E1-1/48)

, 1/4(6 hrs)

Excellent, how to adapt slightly also to show blank if column H holds a Y value (continue with formula if holds N value)

 

[Momentman]

Assuming it is only N that makes it execute then the formula, then

=IF(H1="N",IF(G1-E1<1/4,G1-E1-1/96,G1-E1-1/48),"")

 

[redspanna]

Assuming it is only N that makes it execute then the formula, then

=IF(H1="N",IF(G1-E1<1/4,G1-E1-1/96,G1-E1-1/48),"")

Thank you kind Sir - perfect