Converts an hour, minute, and second into a time.
Sample Usage
TIME(10,40,49)
TIME(C5,C6,C7)
Syntax
TIME(hour, minute, second)
- hour - The hour component of the time.
- minute - The minute component of the time.
- second - The seconds component of the time.
Examples
TIME(10,40,49) returns the time string 10:40:49 AM.
TIME(C5,C6,C7) returns the time string using the values in C5, C6 and C7 as hours, minutes and seconds respectively.
Notes
- The arguments must be numbers - if a string or a reference to a cell containing a string is provided, the #VALUE! error will be returned.
- TIME recalculates numeric time values which fall outside of valid ranges. For example, TIME(25,0,0) returns a time string of 1:00 AM.
- Decimal inputs will be truncated.