Estimated Time of Departure and actual time of departure

[Julius575]

Hi Excel community,

seeking your assistance to provide formula for column Q,

Column Q must mark as 1 if on-time, since actual time of departure is ahead (column K)

vs estimated time of departure (column I).

24 hrs already converted into minutes.

[#2]

@Julius575 Try this instead:

=IF(K4="","",--(I4+1>=K4))

This will return 1 in the given example.