24h time cross midnight; Nested IF not working for an earlier time

A2= 0:15 (12:15am in 24h time)

B2=0:14

Formula:

=IF(B2<A2, (B2+1)-(A2), (B2-A2))

I keep getting "1439 min" as result; however if the B2 cell time is BEFORE A2, I want the result to be "0 min" ..I cannot get the nested IF statement to do what I need. (This formula works great for crossing midnight and all times if A2 is consistently before B2 and I need to keep this base-formatting for when the time's cross midnight (i.e. A2= 23:55, B2= 00:05 = "10 min")). My goal is to count everything in minutes (not h:mm) i.e A2=23:00 B2=00:15 = "75 min"

My cell format is [m] "min"

I hope this makes sense. Any and all suggestions are appreciated

I'm sorry it is hard to describe which is why the IF needs to be in there... I am very green to excel and in a new development program with my company and trying to build spreadsheets from scratch..

Yes, I need to count minutes, however, if b2 time is Less than a2 time, I want the result to just be "0", not the 1439 as I am getting with the current formula.

formula.png

Ah a date... true... the date is not included, just times :-/

ok so without a date... can I add a nested formula to say "if the number is over 1000, make it 0" ?

Thank you so much for your response. This has been driving me nuts now for 2 days and in the end, this spreadsheet is going to be very long...I really hope this can be done!

(Oh and b4 is actually BEFORE A4 in this example....however it is the date that this formula does not know...which is 100% my mistake on not thinking about how the computer would read it.... so simple (duh!))

Roel, Yes thank you. Staring as so many numbers and devising formulas I lost the "computer thinking" behind this formula. And yes I was wondering if I can set a limit just as you suggested! I can't get the formula right as I was adding it as a nested IF.... How/where can I set a limit if sum is over 1000?

Originally Posted by Arkadi

Try this one then:

Please Login or Register  to view this content.

OMG!!! It works! I tried it MULTIPLE ways and its PERFECT! Thank YOU!!! I don't think I would have ever been able to come up with the .69xx value (honestly, I'm not even sure how you even obtained that #) but I somehow knew there should have been a 2 and 3rd nested value I just couldn't put my finger on it.

Thanks again Arkadi!!