The TIME function in Excel allows for the creation of time with individual hour, minute, and seconds. This function allows you to combine various time components from individual cells. This is demonstrated in the example below.
=TIME(hour, minute, second)
- hour – (required) the hour. 0 to 32767 representing the hour. Over 23 Excel divides the number by 24. This then becomes the hour.
- minute – (required) the minute. 0 to 32767 representing the minutes. Over 59, Excel converts to hours and minutes.
- second – (required) the second. 0 to 32767 representing the seconds. Over 59, Excel converts to hours, minutes and seconds.
TIME Function in Excel Usage Example:
Let’s look at the following TIME examples. You can easily see how excel processes the input times. For hour values over 23 and minute/seconds over 59, you can see how Excel treats these arguments.
- #NUM! error – All hours must be positive. Excel does not have a flux capacitor and therefore does not deal with negative time.
- #VALUE! error – All values must be numeric.