Microsoft Office Tutorials and References

In Depth Information

**TIME**

TIM
TIME
returns the corresponding serial number of time as a fraction between 0 and

0.99999999.

=TIME(hour,minute,second)

The
TIME
function returns the serial number of the time. The hour can be any number

between 0 and 23. The minute can be any minute between 0 and 59. The second can be any

number between 0 and 59. The serial number is the number associated with the 1900 date

system. For example,
=TIME(8,30,25)
would return the serial number .35446 and Excel

automatically formats this in the date format of 8:30 AM. The date and 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 calculation tab. If a user wishes to derive a time from other time figures (either in

cells, or in quotes), they will need to use other time functions to convert those time figures

into their serial counterparts…

=TIME(HOUR(B4),MINUTE(B6),SECOND(B5)).

The number between 0 and 23 that represents the hour.

HOUR

The number between 0 and 59 that represents the minute of the hour.

MINUTE

The second between 0 and 59 that represents the second of the minute.

SECOND

TIMEVALUE

Returns the serial number represented by text as time.

=TIMEVALUE(time_text)

The
TIMEVALUE
function is similar to the
TIME
function in that it returns the serial number of

time as a decimal or fraction between 0 and 0.99999999. However, the
TIMEVALUE
function

converts time text to a serial number. For example,
=TIMEVALUE(“8:30 AM”)
returns the

serial number value of .35417. If you include a date in the
time_text
argument, the date will

have no bearing on the result. Also,
=TIMEVALUE(“4/3/99 8:30 AM”)
would return a value of

.35417
.

The text string that gives the time in any Excel time format.

TIME TEXT

TODAY

TODAY
returns the current date as a serial number. There are no arguments for this function.

=TODAY()

The
TODAY
function is a powerful dynamic function that allows you to see the current day

ever y time the workbook is opened, calculated, or printed. You could place the
TODAY

function in a cell on a report so you always have the current day posted on the report, or, you