Time difference if function formula

Question

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.

Answer 1

t if advance time for ATD column - Can you translate this for me in maths terms?

No delays means - 00:00 in Delays column?

Answer 2

Hi Ms. Arya,

can you still help me, what if advance time for ATD column, no delays , then still it should be equal to 1.

I mean if the delay value is equivalent to ##### due to advance time of departure (ATD), would that be possible to equal to 1.?

advance date or  0-15 mins =actual column should be equal to 0

Answer 3

It would work for exact 15 mins to be 0.

Check if you have seconds in your time 00:15:01 will be displayed as 00:15 whereas it is greater than 00:15 because it carries seconds also.

If you have seconds also, use below formula

=--(--TEXT(O2,"h:mm")>--"0:15")

Answer 4

yes it didn't work... if exact 15 mins delay it should be equal to 0.

0-15 mins = actual column should be equal to 0

16 mins to 60mins+ = actual column should be equal to 1.

Answer 5

Hello Julius

I am V. Arya, Independent Advisor, to work with you on this issue. I think I did reply to this and provided following formula? Didn't it work.

=--(O2>--"0:15")