Microsoft Office Tutorials and References
In Depth Information
NOW
NOW NOW returns the current date and time in the form of a serial number. There are no arguments
for this function.
=NOW()
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
calcualtion tab.
Figure 4.8
The NOW function
returns the exact time
the function was
entered down to the
second.
1
Year
B
Month
D
Time
C
Day
SECOND
SECOND returns the corresponding serial number of seconds as an integer between 0 and 59.
=SECOND(serial_number)
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.
Search JabSto ::




Custom Search