TIMEVALUE
Category: DateTime Function.
Description: Converts a text representation of time into a decimal number that represents time.
Syntax: TIMEVALUE(time_text)
Date information in time_text is ignored.
The decimal number is calculated as a portion of a date value (24 hours is 1.0, so 3 AM is 0.125 in decimal time).