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.