이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
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)결과: 12:30 PM
Returns the serial number for 12:30 PM.
Excel divides the number by 24 and treats the remainder as the hour.