When data is entered in a cell, the adjacent cell records the current time. This is a sheet for machine operators to keep track of their progress. Go to Tools Options Calculation Tab Check the Iteration checkbox. Use the IF and NOW functions as shown in the following formula:
Apply "mm/dd/yyyy hh:mm" format to column B.