Converts a time in the form of text to a serial number representing a time.
This function works the same in Google Sheets as it does in Excel — same syntax and arguments.
TIMEVALUE(time_text)The TIMEVALUE function converts a time string into a decimal number that Excel recognizes as a time value, ranging from 0.0 to 0.99988657. This is useful for performing calculations on times that are stored as text in your worksheet.
=TIMEVALUE("6:30 PM")Result: 0.770833
Converts the text string '6:30 PM' into its corresponding decimal time value.
The number represents a fraction of a 24-hour day, where 0.5 equals 12:00 PM.