TIMEVALUE()
Syntax. TIMEVALUE(time_text)
Definition. This function converts a time formatted as text into a time value (serial number). The serial number is a value in the range of 0 through 0.99999999 and corresponds to a time from 00:00:00 through 23:59:59.
Arguments
Time_text (required). A text value in any Excel time format. Dates in the time argument are ignored.
Background. If a time is formatted as text (for example, in values that have been imported), use the TIMEVALUE() function to convert the time into a serial number. You can use the result for other calculations.
Most functions convert times formatted as text automatically into serial numbers, but if you use imported data or worksheet functions from a third-party add-in, this might not ...
Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
