Colume B = Date in mm/dd/yyyy format
Column G = Depart Time In HH:MM (24Hour) Format
Column I = Flight time in number format ( ie 2.15 Hours)

What I would like is an If/else statement so that:

Regardless of year....

if Depart time is "March or before" or "November or after" AND after 18:00 (6pm) ....input value From Column I
Or
if Depart time is 20:00 (8pm)...........input Value from Column I

Else input value of "0"