January 9, 2019
A2= 0:15 (12:15am in 24h time)
=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" Unfortunately there are no dates set specifically with each time. Is there a way to add a limit so that "if cell is >1000, then "0 min" " ?
My goal is to count everything in minutes (not h:mm) i.e A2=23:00 B2=00:15 = "75 min" ; therefore, my cell format is [m] "min" BUT # "min" works as well in only "most" of these cases.
I hope this makes sense. Any and all suggestions are appreciated.
=IF(IF(B3<A3, (B3+1)-(A3), (B3-A3))>0.694444444444445,0,IF(B3<A3, (B3+1)-(A3), (B3-A3)))