| Function category | Date and time functions |
| Volatility | Non-volatile |
| Similar functions | DATE |
What does this function do
The TIME function is used to create a time value in Excel format based on specified hours, minutes, and seconds. This is useful when you want to assemble a time value from separate numbers or calculations.
Syntax:
=TIME(hour, minute, second)Arguments:
- hour — number from 0 to 32767. Values exceeding 23 are converted to days. For example, 25 hours becomes 1 day and 1 hour (01:00 of the next day).
- minute — number from 0 to 32767. Similarly, 60 minutes becomes 1 hour.
- second — number from 0 to 32767. 60 seconds equals 1 minute, and so on.
Examples
=TIME(14, 30, 0)Result: 14:30 — displays as 2:30 PM in time number format.
If you enter:
=TIME(27, 0, 0)Result: 03:00 (1 day + 3 hours).
Practical applications:
- Creating time values from numbers obtained through calculations
- Forming timestamps from data
- Simplifying schedule and timing construction
- Building time values when components are in separate cells
- Calculating time intervals and durations
Other Date and Time functions in Excel
TIMEVALUE, YEAR, DATE, DATEVALUE, EDATE, DAY, WEEKDAY, YEARFRAC, EOMONTH, MONTH, MINUTE, WEEKNUM and WEEKNUM.ISO, WORKDAY, DATEDIF, TODAY, SECOND, NOW, HOUR, NETWORKDAYS
Like the article? Help its author! Buy !SEMTools, it has lots of useful instruments to process text data.
This post is also available in RU.