Estimated Time of Departure and actual time of departure

Question

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.&nbsp;

riny_van_eekelen · Answer

Julius575&nbsp;Try this instead:=IF(K4="","",--(I4+1&gt;=K4))This will return 1 in the given example.&nbsp;&nbsp;

Forum Discussion

Estimated Time of Departure and actual time of departure

1 Reply