Forum Discussion

Copper Contributor

Sep 27, 2018

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...

excel

Excel on Mac

Formulas and Functions

office 365

Detlef_Lewin

Silver Contributor

Sep 28, 2018

Lorenzo Kim

Why would you use CONVERT()?

=IF(B2-A2>1,"Not ","")&"Stocked"

Lorenzo Kim

Bronze Contributor

Sep 28, 2018

I computed the difference in hours between 2 dates..
since 24 hrs = 1 day - your formula is also correct...

and much shorter. NEAT!
thanks..