Subtraction of formula contained time cells

Dear Excel Master,
I am working on a sheet with calculations of time, in which i want to sutract

"RTG Deployed in Ops Hrs (E4-D4)"

minus

"RTG Not Available/BD in R4 with contain a formula i.e. "G4-F4+(G4<F4)*24)+(I4-H4+(I4<H4)*24)+(K4-J4+(K4<J4)*24)+(M4-L4+(M4<L4)*24)+(O4-N4+(O4<N4)*24)+(Q4-P4+(Q4<P4)*24)"

and result should be reflect in "RTG Ops Available Hrs" in S4

for example (format HH:MM) 07:00 - 03:40 = 3:20, i have updated this manulaly as

Please help me to resolve the same.

Thanks in advance.

RavindraK

I agree with Glenn and your times in d and E are formatted as text , F:Q are numbers

r4 should be
=IF(F4>G4,1,0)+G4-F4 +IF(H4>I4,1,0)+I4-H4+IF(J4>K4,1,0)+K4-J4+IF(L4>M4,1,0)+M4-L4+IF(N4>O4,1,0)+O4-N4+IF(P4>Q4,1,0)+Q4-P4

s4

if(d4>e4,1,0)+e4-d4-r4

Sorry,
12:00 - 3:40 = 8:20

Much better solution than mine Bo-Ry

Bo_Ry,
Superb, Yes, it's working as expected, You are Charm !!!
Thanks a lot.

Thanks to davsth also.

Ravindrak