Background: Our help desk software sucks, so every morning I export a list of the tickets out to a spreadsheet. I created a template that I paste the export into and it formats it the way I like, ...
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.