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.

Learn MS Excel


Ask Questions

Ask Question