TIMEVALUE function
Summary
Converts a time in the form of text to a serial number
Syntax
TIMEVALUE(time_text)
The TIMEVALUE function syntax has the following arguments:
• Time_text Required. A text string that represents a time in any one of the Microsoft Excel time formats; for example, "6:45 PM" and "18:45" text strings within quotation marks that represent time.
• Time_text Required. A text string that represents a time in any one of the Microsoft Excel time formats; for example, "6:45 PM" and "18:45" text strings within quotation marks that represent time.
Example
=TIMEVALUE("2:24 AM")
=TIMEVALUE("22-Aug-2011 6:35 AM")
=TIMEVALUE("22-Aug-2011 6:35 AM")