ReferenceFunctionsDate & Time Functions
TIME
Returns the fractional-day serial for a time built from hour, minute, and second.
Summary
TIME normalizes overflowing and negative components by wrapping across day boundaries.
Remarks
- The result is always in the range
0.0..1.0and represents only a time-of-day fraction. - Values are normalized like Excel (for example,
25hours becomes01:00:00). - Time fractions are date-system independent because they do not include a date component.
Examples
Create noon
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.5
Wrap overflowing hour
Grid
| Cell | Value | |
|---|---|---|
| No inputs on Sheet1. | ||
Formula
=
Result
Not evaluated yet.
Expected
0.0416666667
Related functions
FAQ
Can TIME return values greater than 1 day?
No. TIME wraps overflow and always returns a fraction in [0,1), so extra days are discarded.
Runtime metadata
Category
Date & Time
Signature
TIME(arg1: Number, arg2: Number, arg3: Number)Arity
min 3, max 3
Arguments
arg1Number · Scalar · coercion NumberLenientText
arg2Number · Scalar · coercion NumberLenientText
arg3Number · Scalar · coercion NumberLenientText
Caps
PURE
Source