if function

  • Thread starter Thread starter octet32
  • Start date Start date
O

octet32

I have the time in cell A2 {=now( )} I amtrying have a
cell change when it hit IF becomes 14:00 is this possible?
I tryed using the function below it didnt work
=IF(A2>14:00,"Completed","On Time")
Does anyone Know how to do this?
Thanks
 
try
=if(hour(now())>=14,"Completed","On time")

But tomorrow morning when you open the workbook, it will return "on Time".
 
Back
Top