TIME Function
The TIME function returns the actual time from the given separate hour, minute and second values.
Formula:
=TIME(Hour, Minute, Second)
whereas "Hour" can be any number from 0 to 32767. (If the value is greater than 23, then the function divides the same by 24 and takes the remaining number).
"Minute" can be any number from 0 to 32767. (If the value is greater than 59, then the function divides the same by 60 and takes the remaining number).
"Second" can be any number from 0 to 32767. (If the value is greater than 59, then the function divides the same by 60 and takes the remaining number).
Video Tutorial:
Let us find the time from the given values, using TIME function, with the help of the below video.
