Returns the decimal number for a particular time.
Söz dizimi
TIME(hour, minute, second)Bağımsız değişkenler
hourzorunlu
A number from 0 to 32767 representing the hour.
minutezorunlu
A number from 0 to 32767 representing the minute.
secondzorunlu
A number from 0 to 32767 representing the second.
The TIME function converts hours, minutes, and seconds into a serial number that Excel recognizes as a time format. The result is a decimal fraction ranging from 0 to 0.99988426, representing the time from 0:00:00 to 23:59:59.
=TIME(12, 30, 0)→12:30 PMReturns the serial number for 12:30 PM.
Enter the function
Type =TIME( into the cell where you want the result.
Input arguments
Provide the hour, minute, and second values separated by commas.
Format the cell
Apply a time format to the cell to display the result as a readable time.
Excel divides the number by 24 and treats the remainder as the hour.