I admit I'm not an excel fan, but this is very handy:
To insert current date, press CTRL-; in the chosen cell. To insert current time, press CTRL-SHIFT-;. To insert current date and time together, press CTRL-;-SPACEBAR CTRL-SHIFT-;