TIME Function - Excel
Overview
The TIME function in Excel is a useful tool for creating a time value by specifying the hour, minute, and second as individual arguments.
Example:
=TIME(14, 27, 35)
Syntax:
=TIME(hour, minute, second)
hour: The hour for the time (a number between 0 and 23).
minute: The minute for the time (a number between 0 and 59).
second: The second for the time (a number between 0 and 59).
Example
In this example, the TIME function is given a 12 for the hour input, a 32 for a minute input, and a 10 for the second input . The final output of the function is “12:32:10 PM”.
