Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
91
Views
Topic starter
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" 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.
SOLVED**
=IF(IF(B3<A3, (B3+1)-(A3), (B3-A3))>0.694444444444445,0,IF(B3<A3, (B3+1)-(A3), (B3-A3)))
Posted : 09/01/2019 2:07 pm
Use this formula
=(B2-A2+(B2<A2))*24*60)
Posted : 10/01/2019 3:38 am
