Ctrl+;

Insert static date

Ctrl+Shift+;

Insert static time

Ctrl+;, then Space, then Ctrl+Shift+;

Insert static date followed by time

=TODAY()

Insert todays date as formula

=NOW()

Insert todays date and time as formula

Ctrl+Shift+3

Apply date format to selection as dd-mmm-yy

Ctrl+Shift+2

Apply time format to selection as h:mm AM/PM

Ctrl+1

Access Format Number menu (press Ctrl+Tab if tab Is not in focus, press Tab or Ctrl+T for Type to access number format)

M

Month as single digit (e.g. 1/23/2020)

mm

Month as double digits (e.g. 01/23/2020)

mmm

Month abbreviated 3-letter (e.g. Jan/23/2020)

mmmm

Month as full name (e.g. January/23/2020)

mmmmm

Month as abbrevated 1 letter (e.g. J/23/2020)

D

Day as 1 digit number (e.g. 1/1/2020)

dd

Day as 2 digit number (e.g. 1/01/2020)

ddd

Day as 3-digit abbrevation (e.g. 1/Wed/2020)

dddd

Day as full name (e.g. 1/Wednesday/2020)

Y

Year as 2 digit number (e.g. 1/1/20)

yy

Year as 4 digit number (e.g. 1/1/2020)

Ctrl+1

Access Format Number menu (press Ctrl+Tab if tab Is not in focus, press Tab or Ctrl+T for Type to access number format)

H

Hours without leading zero

hh

Hours with leading zero

M

Minutes without leading zero

mm

Minutes with leading zero

S

Seconds without leading zero

ss

Seconds with leading zero

AM/PM

Display AM or PM

H

Time elapsed in hours (Hours in 24-hour format)

M

Time elapsed in minutes

M

Time elapsed in minutes

mmm

Month abbreviated 3-letter (e.g. Jan/23/2020)

mmmm

Month as full name (e.g. January/23/2020)

mmmmm

Month as abbrevated 1 letter (e.g. J/23/2020)

D

Day as 1 digit number (e.g. 1/1/2020)

dd

Day as 2 digit number (e.g. 1/01/2020)

ddd

Day as 3-digit abbrevation (e.g. 1/Wed/2020)

dddd

Day as full name (e.g. 1/Wednesday/2020)

Y

Year as 2 digit number (e.g. 1/1/20)

yy

Year as 4 digit number (e.g. 1/1/2020)