Spread 8.0 Documentation
TIME
Support Options
Formula Reference > Built-In Functions > TIME

Glossary Item Box

TIME


Name

Time

Description

Returns the serial value for a specified time.

Syntax

TIME(hour, minute, second)

Remarks

Arguments are as follows:

Argument Description
hour Hour as a number from 0 to 23.
minute Minutes as a number from 0 to 59.
second Seconds as a number from 0 to 59.

Spread's calc engine processes dates as a numeric value in the form x.y, where x is the "number of days since December 30, 1899" and y is the fraction of day. Numbers to the left represent the date, which is the value that the DATE function returns. Use the TIME function to return the serial value for the time value (the fraction of a day).

The time serial value is a decimal fraction ranging from 0 to 0.99999999, representing the times from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.).

See also DATE, DAY, HOUR, MINUTE, MONTH, NOW, SECOND, TODAY, WEEKDAY, and YEAR.

Data Type

Accepts numeric data. Returns numeric data. For more information, see Data Type for Each Cell Type.

Example

TIME(A1,B1,C1)
TIME(12,0,0)= 0.5 equivalent to 12:00:00 P.M.
TIME(16,48,10)= 0.700115741 equivalent to 4:48:10 P.M.

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.