Returns the decimal number for a particular time.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
TIME(hour, minute, 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)Kết quả: 12:30 PM
Returns the serial number for 12:30 PM.
Excel divides the number by 24 and treats the remainder as the hour.