TIMEVALUE
Returns the decimal number of the time represented by a text string
Syntax
TIMEVALUE(time_text)
Parameters
- time_text: Required. A text string that represents a time in any one of the Microsoft Excel time formats
Example
=TIMEVALUE("2:30 PM")