Formula for Date and Time in same column

[robinmech]

Hi,


Can anybody help me to solve this.


I Want to get the date and time against my each entry in the excel sheet. When I used the "NOW" function time and dates are changing based on the day and time for all the entries. I want to keep each entry as it is in order to track. Please help m with a function code or formula.

Thanks in advance

 

[sandy666]

maybe: CTRL+; space, CTRL+SHIFT+; it will give you: 01/08/2018 09:58 in the same cell

 

[sandy666]

or timestamp in B2: =IF(A2="","",IF(B2="",NOW(),B2))
if you add something in A2 then you will get date and time in B2 "frozen"
iterative calculation must be enabled. Options - Formulas - Enable iterative calculation