NOW
Returns the serial number of the current date and time.
Date & TimeBeginner EssentialsDates & Time CalculationsMost Used
What it does
Returns the current date and time (updates when the workbook recalculates).
Syntax
NOW()
Examples
Hours since a timestamp
Calculate hours since the timestamp in A2.
FORMULA
=(NOW()-A2)*24
RESULT
(varies)
SAMPLE DATA
| A | |
|---|---|
| 1 | Timestamp |
| 2 | 2026-01-01 12:00 |