Share via

Time difference if function formula

Anonymous
2020-01-08T05:39:00+00:00

Hi Excel Community,

Please assist in creating formula below.

if the time difference is less than or equal to 15mins, the actual column should be equal to zero(0). If the time difference is greater than 15 minutes, the actual column should be equal to one (1) .

Highly appreciated your assistance on this.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

9 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-01-09T00:44:37+00:00

    thank you so much! it works! =)

    Was this answer helpful?

    0 comments
  2. Anonymous
    2020-01-08T12:04:47+00:00

    See my screen shot below,

    Try this formula at

    O2    =IF(L2<>"",MAX(0,L2-K2),"")

    P2    =IF(L2="","",--((K2+TIME(0,15,0))>=L2))

    and drag it down till you have data. You should get your desired results.

    Hope it helps.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2020-01-08T10:16:41+00:00

    You should use below formula for Delays (format your result set as time)

    =--TEXT(K2-L2,"[h]:mm")

    Was this answer helpful?

    0 comments
  4. Anonymous
    2020-01-08T07:59:00+00:00

    In connection with the delays column, we have proforma ETD (estimated time of Departure) and ATD (actual time of departure)

    ATD = 12/25/2019  5:00:00 PM

    ETD = 12/26/2019  4:30:00 PM

    the time difference on this is one day due to ahead of departure (ATD), the result is no delay since departure is ahead of time. the results in the actual column section should be equal to 1. since ATD is ahead of time.

    Was this answer helpful?

    0 comments