# TimeSerial Function

μ«μ κ°μΌλ‘ μ λ¬λλ μ§μ ν μκ°, λΆ λ° μ΄ λ§€κ° λ³μμ λν΄ μ°μ μκ° κ°μ κ³μ°ν©λλ€. μ΄ κ°μ μ¬μ©νμ¬ μκ° μ°¨λ₯Ό κ³μ°ν  μ μμ΅λλ€.

## κ΅¬λ¬Έ:

``````
TimeSerial (hour, minute, second)
``````

λ μ§

## λ§€κ° λ³μ:

hour: μ°μ μκ° κ°μ νμΈνλ λ° μ¬μ©λλ μκ°μ λνλ΄λ μμμ μ μ μμλλ€. μ ν¨ν κ°: 0-23.

minute: μ°μ μκ° κ°μ νμΈνλ λ° μ¬μ©λλ λΆμ λνλ΄λ μμμ μ μ μμλλ€. μΌλ°μ μΌλ‘ 0μμ 59 μ¬μ΄μ κ°μ μ¬μ©νμ§λ§ λΆ μκ° μκ° κ°μ μν₯μ μ£Όλ κ²½μ° μ΄ λ²μλ₯Ό λ²μ΄λλ κ°μ μ¬μ©ν  μ μμ΅λλ€.

second: μ°μ μκ° κ°μ νμΈνλ λ° μ¬μ©λλ μ΄λ₯Ό λνλ΄λ μμμ μ μ μμλλ€. μΌλ°μ μΌλ‘ 0μμ 59 μ¬μ΄μ κ°μ μ¬μ©νμ§λ§ μ΄ μκ° λΆ κ°μ μν₯μ μ£Όλ κ²½μ° μ΄ λ²μλ₯Ό λ²μ΄λλ κ°μ μ¬μ©ν  μ μμ΅λλ€.

μ:

12, -5, 45λ 11, 55, 45μ ν΄λΉν©λλ€.

12, 61, 45λ 13, 2, 45μ ν΄λΉν©λλ€.

12, 20, -2λ 12, 19, 58μ ν΄λΉν©λλ€.

12, 20, 63μ 12, 21, 4μ ν΄λΉν©λλ€.

TimeSerial ν¨μλ₯Ό μ¬μ©νμ¬ μμμ μκ°μ μκ° μ°¨λ₯Ό κ³μ°νλ λ° μ¬μ©ν  μ μλ λ¨μΌ κ°μΌλ‘ λ³νν  μ μμ΅λλ€.

TimeSerial ν¨μλ VarType 7μ Variant νμ(Date)μ κ΅¬ν©λλ€. μ΄ κ°μ λ΄λΆμ μΌλ‘ 0μμ 0.9999999999 μ¬μ΄μ λ°°μ λ°λ μ«μλ‘ μ μ₯λ©λλ€. κ³ μ  λ μ§λ₯Ό κΈ°μ€μΌλ‘ μ°μ λ μ§ κ°μ΄ λ μ§λ‘ κ³μ°λλ DateSerial λλ DateValue ν¨μμ λ¬λ¦¬ TimeSerial ν¨μλ₯Ό μ¬μ©νμ¬ κ΅¬ν κ°μ κ³μ°νλ λ°μλ μ¬μ©ν  μ μμ§λ§ μ΄ κ°μ νκ°ν  μλ μμ΅λλ€.

TimeValue ν¨μμλ λ¬Έμμ΄μ μκ°μ ν¬ν¨νλ λ§€κ° λ³μλ‘ μ λ¬ν  μ μμ΅λλ€. κ·Έλ¬λ TimeSerial ν¨μμ κ²½μ°μλ μκ°, λΆ, μ΄ λ±μ κ°λ³ λ§€κ° λ³μλ₯Ό λ³λμ μ«μ μμΌλ‘ μ λ¬ν  μ μμ΅λλ€.

### Error codes:

5 μλͺ»λ νλ‘μμ  νΈμΆμλλ€.

## μ:

``````
Sub ExampleTimeSerial
Dim dDate As Double, sDate As String
dDate = TimeSerial(8,30,15)
sDate = TimeSerial(8,30,15)
MsgBox dDate,64,"Time as a number"
MsgBox sDate,64,"Formatted time"
End Sub
``````