GOOGLECLOCK Returns the current system date and time and updates automatically once per minute.
GOOGLECLOCK
is not available in the new Google Sheets. To get the same results, use the NOW
function and change your recalculation setting to "On change and every minute" in your spreadsheet at File > Spreadsheet settings.
Sample Usage
GOOGLECLOCK()
Syntax
GOOGLECLOCK()
Notes
-
GOOGLECLOCK
works similarly toNOW
except it updates automatically rather than only on recalculation.
See Also
NOW
: Returns the current date and time as a date value.
Examples
Returns the current date and time according to the computer system.