I am using excel to scan bar codes and want it to record the date and time when each one is scanned. I originally tried to use this formula IF(A1>"",Now(),""). It displays the date and time of the scan, but when I edit another cell the time updates to the current time. Is there another formula I could use to capture the date and time? Thanks for any help you can provide.