Return the current time

You can return the current time by using the NOW function.
This function returns the serial number of the current system date and time.


Cell "A1" displays the current date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".

 A
1=TODAY() = Sunday 01 May 2022
2=NOW() = Sunday 01 May 2022 18:37:54
3=NOW()-TODAY() = 18:37:54

Shortcut Keys

(Ctrl + Shift + ;) - Enters the current time into the active cell


Built-in Functions

NOW - The serial number of the current system date and time.
TODAY - The serial number representing today's date.


Related Formulas

Return the current date and time
Return the current date
Return the current day
Return the current month
Return the current time


© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top