Microsoft Office Tutorials and References
In Depth Information
NOW NOW returns the current date and time in the form of a serial number. There are no arguments
for this function.
The NOW function calculates the time the function was entered or when a worksheet is calculated.
This function is not updated continuously on the worksheet. The NOW function will show the
current time when a worksheet is printed, or the workbook is opened. The NOW function could be
in the form of a year, month, day, hour, minute, or second. Notice the example in Figure 4.8. The
time this formula was entered is calculated down to the second. The date value of Windows date
systems is any date from 1/1/1900 to 12/31/9999. The date value of Macintosh systems is any
date from 1/1/1904 to 12/31/9999. In the O ptions dialog box from the T ools menu, you can
change the date system of an Excel for Windows system to the 1904 d ate system found on the
The NOW function
returns the exact time
the function was
entered down to the
SECOND returns the corresponding serial number of seconds as an integer between 0 and 59.
The SECOND function operates on serial numbers between 0 and 59. There are 60 seconds in a
minute, so 30 equals 30 seconds. The function operates as follows: =SECOND(“8:25:30”) =30 .
The serial number for the SECOND function is the date and time code Microsoft Excel uses for
date and time calculations.