If you type into a cell
then press F9 then press Enter it will enter the current time & date. You need to format the cell accordingly.
If you want this to happen automatically it can be done using a macro that uses the WorkSheet_Change property. We would need to know the name of the sheet and which row or column entry has to trigger this.