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
Search JabSto ::




Custom Search