Forum Discussion
Excel Formula help - IF statements?
Hi guys, I want to differentiate these two columns. If the difference in time between "Order Date" and "Printed Date" is less than 24 hours I want the data to say "Stocked". If the differe...
try:
=IF((CONVERT(L2,"day","hr")-CONVERT(K2,"day","hr"))>24,"Not stocked","Stocked")
hope this helps..
=IF((CONVERT(L2,"day","hr")-CONVERT(K2,"day","hr"))>24,"Not stocked","Stocked")
hope this helps..
I computed the difference in hours between 2 dates..
since 24 hrs = 1 day - your formula is also correct...and much shorter. NEAT!
thanks..
- the cell where the formula will be put must be formatted to "General" NOT TIME..
Wow, thank you so much!! You've literally saved me hours
- glad to help...
the above should do it.
sorry, the first post is only computing hours - not including the days ...
