Hi All,
I am trying to time stamp a cell in excel to show the time and date an entry was made. I pulled the below code from the net and modified it with the if statement. It works in the way I want but the issue is when I duplicate it down the column for time stamping each entry all the time entry's are aligning to the last input. Thats to say if someone puts data into row D1 and the code time stamps it to 08:00am then ten minutes later someone puts data into row D2 both times align and show as 08:10. When what I am trying to achieve is D1 = 08:00am and D2=08:10am.
Really appreciate any advise to correct this problem along with an explanation why the code is linking in like this.
=IF(D1="","",TEXT(TODAY(),"d-mmmm-yyyy")&" "& TEXT(NOW(), "h:mm AM/PM"))
=IF(D2="","",TEXT(TODAY(),"d-mmmm-yyyy")&" "& TEXT(NOW(), "h:mm AM/PM"))
I am trying to time stamp a cell in excel to show the time and date an entry was made. I pulled the below code from the net and modified it with the if statement. It works in the way I want but the issue is when I duplicate it down the column for time stamping each entry all the time entry's are aligning to the last input. Thats to say if someone puts data into row D1 and the code time stamps it to 08:00am then ten minutes later someone puts data into row D2 both times align and show as 08:10. When what I am trying to achieve is D1 = 08:00am and D2=08:10am.
Really appreciate any advise to correct this problem along with an explanation why the code is linking in like this.
=IF(D1="","",TEXT(TODAY(),"d-mmmm-yyyy")&" "& TEXT(NOW(), "h:mm AM/PM"))
=IF(D2="","",TEXT(TODAY(),"d-mmmm-yyyy")&" "& TEXT(NOW(), "h:mm AM/PM"))