TIME
Date & TimeTIME helps you perform date and time helpers for scheduling, intervals, and calendar-aware calculations.
Overview
Start with "=" then enter TIME(hour, minute, second). Keep argument order as shown and use cell ranges where appropriate.
Parser pathComplete docs
Syntax & Arity
=TIME(hour, minute, second)
3 required
Arguments
| Argument | Required | Type | Description |
|---|---|---|---|
| hour | Required | Single | Input argument used by this function. |
| minute | Required | Single | Input argument used by this function. |
| second | Required | Single | Input argument used by this function. |
Example Inputs & Outputs
Formula
=TIME(<hour>, <minute>, <second>)
Example Output
Date or time value
Replace placeholders with your worksheet values or ranges to compute a result.