Converts a time in the form of text to a serial number representing a time.
Sintassi
TIMEVALUE(time_text)Argomenti
time_textobbligatorio
A text string that represents a time in any of the Microsoft Excel time formats.
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")→0.770833Converts the text string '6:30 PM' into its corresponding decimal time value.
Select a cell
Click on the cell where you want to display the converted time value.
Enter the formula
Type =TIMEVALUE("your_time_text") and press Enter.
The number represents a fraction of a 24-hour day, where 0.5 equals 12:00 PM.