TIME
Returns the created time with individual hour, minute and second components.
Syntax
TIME(hour, minute, second)
Arguments
| Argument |
Description |
Required |
hour |
The hour to create the time. |
Required |
minute |
The minute to create the time. |
Required |
second |
The second to create the time. |
Required |
Examples
Create time from components
=TIME(14, 30, 45)
Result ⇒
2:30:45PM
Create noon time
=TIME(12, 0, 0)
Result ⇒
12:00:00PM
Create time from cell values
=TIME(A1, A2, A3)
Result ⇒
9:15:30AM
Set time to 12:30:00 AM
=TIME(0, 30, 0)
Result ⇒
12:30:00AM
Related Functions
Other Date/Time functions:
- DATE - Constructs a date from year, month, and day values.
- DATEDIF - Calculates the number of days, months, or years between two dates
- DATEONLY - Extracts the date component from a datetime value, removing the time portion. The result is in workbook time zone.
- DAY - Returns the day of the month from a date value.
- DAYOFWEEK - Returns the day of the week as a text string
- DAYS - Returns the number of days between two dates
- EDATE - Returns a date on the same day of the month, n months in the past or future.
- EOMONTH - Returns last day of a month as a serial number after adding a specified number of months before or after another date.
- HOUR - Returns the hour component of a specific time as a number between 0-23.
- ISOWEEKNUM - Returns the ISO-8601 week number (1–53) of the year for a given date.
- MINUTE - Returns the minutes of a time value
- MONTH - Returns the month from a date value (1-12).
- NETWORKDAYS - Returns the number of work days between two dates, excluding saturday and sunday.
- NOW - Returns the current date and time as a date value in UTC.
- SECOND - Returns the seconds of a time value
- TIMEVALUE - Returns the decimal number of the time represented by a string. The decimal number is a value ranging from 0 (inclusive) to 1 (exclusive).
- TODAY - Returns the current date as a date value in UTC with time stripped.
- WEEKDAY - Returns the number that corresponds to the week of provided date.
- WEEKNUM - Returns the week number of a specific date
- WORKDAY - Returns the date that is the specified number of working days before or after the start date.
- YEAR - Returns the year from a date value.
- YEARFRAC - Calculates the fraction of the year represented by the number of whole days between two dates
← Back to Formula Reference