87
TIME (
hour
,
minute
,
second
)
Returns the fractional value of a
particular time, where hour is a value
from 0 to 24, minute is a value from 0
to 60, second is a value from 0 to 60.
Example: TIME (15,32,39) returns
0.647674 which is the fractional
number representing 15 hours, 32
minutues and 39 seconds. In this
encoding, 0 hours is represented by
the value 0 and 24 hour is repre-
sented by 1.
DATEVALUE(
date_text
)
Converts its argument to a numeric
serial value counting the days since
the first day of 1900.
Example: DATEVALUE(“10/7/96”)
returns 35345. This number is
displayed as 07-Oct-96 if the cell is
formated as DD-MMM-YY.
TIMEVALUE(
time_text
)
Converts its
time_text
argument to a
fractional number since the beginning
of the day (i.e. midnight).
Example: TIMEVALUE(“10:30 PM”) is
equal to 0.9375. This number is
displayed as 22:30:00 if the cell is
formatted as HH:MM:SS.
NOTE
Valid date-text and time-text are:
Representations Example
DD-MMM-YY 28-Dec-96 <date_text>
DD-MMM 28-Dec <date_text>
MMM-YY Dec-96 <date_text>
HH:MM:SS (AM/PM) 02:34:51 AM <time_text>
HH:MM (AM/PM) 02:34 AM <time_text>
MM/DD/YY 12/28/96 <date_text>
MM/DD 12/28 <date_text>
HH:MM:SS 02:34:51 (24 hour) <time_text>
HH:MM 02:34 (24 hour) <time_text>
To Next Page
Loading...
