A4 Accounting

Entering Date and Time in Excel

There are shortcuts to enter

• the current Date Ctr + ;
• the current Time Ctrl + Shift + :

There isn’t one to enter both.

You can use them in sequence to achieve a date and a time entry.

In sequence press

Ctrl + ;

Space bar

Ctrl + Shift + :

The space separates the date and time and Excel will recognise the entry as a date and time.