How to correctly put the current time and date in an Excel cell?

Question

excel

I wanted to make a simple logging of tasks in excel
there are three columns:
on the first numbering =IF(ETEXT(C2)=TRUE;A1+1;
on the second time and date =IF(ETEXT(C2)=TRUE;TDATE()) in the format DD .MM.YYYY hh:mm:ss
in the third text
So, in the second column, the time and date are always the same, but I would like to write down my time and date for each task, a
link to the file itself