The TIME
function returns a time value to a cell
given a number of hours, minutes and
seconds.
- The syntax
for the function is TIME (hour,
minute, second) .
The function
requires three arguments:
-
"hour" must
have a value between 0 and 23,
- "minute"
must be vetween 0 and 59,
- and "second"
a value bertween 0 and 59.
These values
are then converted into a "time value"decimal
which is automatically recognized as
a time displayed of the form: " hour
: minute : second ".
|
Morning and
Afternoon are also displayed. AM for hour
values less than 12 and PM for hour values
greater than or equal to 12.
For example:
TIME (13,2,12) = 1:02:12 PM
Note: To see the "time value" as
a decimal reformat the cell as a number.
e.g. TIME(6,35,42)= 0.274791667
|
