For this example, we will use the top line of data so...
Type = H6
Time Depart = I6
Time landed = J6
Single Engine In Command = K6
Single Engine Dual = L6
My plan is to add I6
and J6
into L6
if H6
says Dual.
But I6
to add with J6
into K6 if H6
says In Command.
Can anyone help me with my boxes? In L6
I already have the formula (to make box blank if no values in I6
& J6
;
=IF(AND(I6<>"", J6<>""), J6-I6, )