Summary
The Excel TIMEVALUE function converts a time represented as text into a proper Excel time.
Purpose
Get a valid time from a text string
Return value
A decimal number representing a particular time in Excel.
Syntax
=TIMEVALUE (time_text)
Arguments
- time_text – A date and/or time in a text format recognized by Excel.
Usage notes
Time_text should be supplied in a text format that Excel can recognize, for example, “7:09 PM” or “15:30”.
The TIMEVALUE function creates a time in serial number format from a date and/or time in an Excel text format. TIMEVALUE will return a decimal number between 0 and 0.99988426, representing 12:00:00 AM to 11:59:59 PM.
Note: date information is ignored.
