Returns the fraction of a 24-hour day the time represents.
Sample Usage
TIMEVALUE("6:00 PM")
TIMEVALUE(C5)
Syntax
TIMEVALUE(time_string)
- time_string - The string containing the time value.
Examples
TIMEVALUE("6:00 PM") returns the fraction of a 24-hour day the time represents. Here, it returns 0.75.
TIMEVALUE(C5) returns the fraction of a 24-hour day represented by the time string in cell C5.
Notes
- The string of text used in time_string should be within quotations and represent time using either the 12-hour or 24-hour time format, for example "2:15 PM" or "14:15".
- TIMEVALUE returns a number between 0 (inclusive) and 1 (exclusive).