Timeline for Is there any way to create a timestamp in a Google Spreadsheet?
Current License: CC BY-SA 3.0
13 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Mar 28, 2020 at 10:15 | comment | added | davidbourguignon | It is documented in the Google Spreadsheets help section, but does not seem to work, alas... I used the NOW() copy-paste trick instead (see other section). | |
| Mar 26, 2020 at 14:53 | comment | added | dancow | Don't know when this shortcut was added on the Mac side (been using Command-semicolon to do the date for the past few years), but Command-Alt-Shift-colon does insert the full timestamp for MacOS+Chrome. Assuming the aforementioned Windows shortcuts also work, sans the use of AutoHotKey, this should be the accepted answer | |
| May 11, 2018 at 11:55 | comment | added | Philippe Gachoud | Not working on firefox linux :-( is there a way to get this function through menus??!! | |
| Jul 18, 2017 at 20:18 | history | edited | user135384 | CC BY-SA 3.0 |
now we have one for date-time!
|
| S May 10, 2015 at 12:31 | history | suggested | Rubén - Volunteer Moderator -♦ | CC BY-SA 3.0 |
Changed Google Docs to Google Sheets as the question is about the last one and the shortcuts apply to it.
|
| May 9, 2015 at 18:27 | review | Suggested edits | |||
| S May 10, 2015 at 12:31 | |||||
| Sep 25, 2012 at 18:54 | history | edited | Jeff Atwood | CC BY-SA 3.0 |
added 2 characters in body
|
| Sep 7, 2012 at 17:26 | comment | added | jimmyorr | Nice! Note, this only works for Spreadsheets, not Documents. | |
| Jul 9, 2012 at 14:21 | comment | added | MrWhite | This is similar to Microsoft Excel, however, unlike Excel you can't seem to follow one shortcut with another in order to produce a complete timestamp. The shortcut in Google Docs only seems to work when the entire cell is selected, not when it is being edited, so you can only get the date OR the time with this method, not both. | |
| S Jun 7, 2012 at 16:16 | history | suggested | Shannon Wagner | CC BY-SA 3.0 |
Added more details, improved formatting, and added reference to support document.
|
| Jun 7, 2012 at 15:51 | review | Suggested edits | |||
| S Jun 7, 2012 at 16:16 | |||||
| Mar 13, 2012 at 18:46 | history | edited | Alex | CC BY-SA 3.0 |
added 34 characters in body; deleted 3 characters in body
|
| Mar 13, 2012 at 18:40 | history | answered | Danniogirl | CC BY-SA 3.0 |