Microsoft Excel Functions & Formulas

Use the NOW function to show the current time

The previous tip described how to get the current date. Now we

want to determine the current time. The NOW function returns the

serial number of the current date and time. Microsoft Excel stores

dates as sequential numbers so they can be used in calculations. By

default, January 1, 1900, is number 1, and January 1, 2006, is num-

ber 38718 because it is 38,717 days after January 1, 1900. Numbers

to the right of the decimal point in the number represent the time;

numbers to the left represent the date. For example, the serial

number .5 represents the time 12:00 noon. The NOW() function is

not updated continuously ...