TIMEVALUE
Converts time given as text to a corresponding serial number. String to time converter.
Syntax
=TIMEVALUE(TimeText)
Arguments
| Name | Type | Description |
|---|---|---|
| TimeText | String | A text which represents a time value. |
Return
| Type | Description |
|---|---|
| Number | A serial number value which corresponds to specified time. |
Examples
| Formula | Result | Comment |
|---|---|---|
| 0.5 | The number to the left of the decimal define the days since 1.1.1900. The number to the right of the decimal define the fraction of the day. |