Converts an hour, minute, and second into a time.
=TIME(hour, minute, second, [millisecond])
- Type: Number
- Description: Returns the time value from specified hours, minutes and seconds.
Sorry, your browser is not supported. MINTDATA™ works best on Google Chrome 50.0+ and Firefox 44.0+.
For TIME function it is necessary to switch the format of the cell to Time in the ‘Automatic’ menu.
TIME will recalculate numeric time which fall outside of valid ranges.
TIME will cut off decimal values input into the function.