- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Date and Time - TIMEVALUE Function
Description
The TIMEVALUE function returns the decimal number of the time represented by a text string.
The decimal number is a value ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
Syntax
TIMEVALUE (time_text)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
Time_text | A text string that represents a time in any one of the Microsoft Excel time formats. | Required |
Notes
Date information in time_text is ignored.
Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day)
If the supplied time_text cannot be recognized as a valid Excel time, TIMEVALUE returns the #VALUE! Error.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016
Example
advanced_excel_date_time_functions.htm
Advertisements