Press Ctrl+; to insert the current date. Press Ctrl+Shift+; to insert the current time. Press Ctrl+; > Space > Ctrl+Shift+; to insert the current date and time together in the same cell.
As different calculations require different formulas, it can be time-consuming to find the exact one. That is why you can ask Copilot to do everything for you in automation. All you need to do is ...