Microsoft Office Tutorials and References
In Depth Information
TIM TIME returns the corresponding serial number of time as a fraction between 0 and
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…
The number between 0 and 23 that represents the hour.
The number between 0 and 59 that represents the minute of the hour.
The second between 0 and 59 that represents the second of the minute.
Returns the serial number represented by text as time.
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
The text string that gives the time in any Excel time format.
TODAY returns the current date as a serial number. There are no arguments for this function.
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