TIMEVALUE
Date

Converts a time in the form of text to a serial number

Syntax:

=TIMEVALUE(time_text)

Example:

=TIMEVALUE("12:00:00 PM")