MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Shortcuts - Time & Date

August 01, 2017 - by Bill Jelen

Excel Shortcuts - Time & Date

How to enter the current time or date into a cell. This method is a shortcut key and is often superior to using NOW() or TODAY().

Press Ctrl + Shift + : to enter the current time. Press Ctrl + ; for the current date. Note the shortcut enters the current time, not a formula.

Thanks to Olga Kryuchkova, Tim O’Mara

Watch Video

Auto-Generated Transcript

  • Learn Excel from MrExcel Podcast
  • episode 2121 control : to enter the
  • current time control semicolon to enter
  • the current date or if I need to
  • timestamp something if I need to say
  • what time something happened like right
  • now I'm recording and says it's 742 so
  • it's 7 : 42 all I have to do is hold out
  • think of : control columns of control
  • shift : puts in the current time and
  • then if I want to do the date just
  • unship that so control semicolon puts in
  • the current date now you're like well
  • why would you do that when you just use
  • now or today or the mod of Val well the
  • problem is these formulas down here are
  • constantly reacting if I open this
  • tomorrow it's not going to say 722
  • anymore it's going to say 723 if I open
  • it six months from now it's going to say
  • 1/1/18
  • I want a timestamp something I want to
  • just lock that time in here's a couple
  • of cool ones if you want to enter the
  • current date and time if you would do
  • let's make this a little bit wider here
  • so we can see the whole thing if we
  • would do ctrl shift : and then ctrl
  • semicolon right like that and it doesn't
  • look like it would work that actually
  • converts to a real date and time it does
  • not work the other way ctrl semicolon
  • ctrl shift : will not work that's
  • Hayes's text all right so a couple days
  • ago we talked about using strikethrough
  • I like to use strikethrough but then I
  • also like to say what time I finish some
  • things that we have kind of a picture my
  • days of ctrl shift : ctrl semicolon lets
  • you put the date and time in when
  • something happened all right thanks for
  • stopping by we'll see next time for
  • another neck cast from MrExcel

Title Photo: Alexas_Fotos / Pixabay

Bill Jelen is the author / co-author of
MrExcel LIVe

A book for people who use Excel 40+ hours per week. Illustrated in full color.