Converts a time in the form of text to a serial number representing a time.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
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")תוצאה: 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.