TIME
Calculates the serial number which corresponds to the time specified by given hours, minutes and seconds
Syntax
=TIME(Hours, Minutes, Seconds)
Arguments
| Name | Type | Description |
|---|---|---|
| Hours | Number | A number between 0 and 23, which specifies hours |
| Minutes | Number | A number between 0 and 59, which specifies minutes |
| Seconds | Number | A number between 0 and 59, which specifies seconds |
Return
| Type | Description |
|---|---|
| Number | A serial number value which corresponds to specified time. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 0.5 | The given time value represents 12:00 AM. |