TIMEVALUE
Description
Returns a numerical time value based on the specified text.
Syntax
TIMEVALUE(
time_text
)
- time_text: The text to convert to a numerical time value. Example: =TIMEVALUE( "2:23 pm" ).
Example
Formula | Result |
|---|---|
=TIMEVALUE("12/31/2016 00:01:01") | 0.000706019 |
=TIMEVALUE("11:59 pm") | 0.999305556 |
=TIMEVALUE("23:59:59") | 0.999988426 |