The TIMEVALUE Function Knowledgebase In Excel

Quantunet.com

My Account

Joins Us

Excel QuickSkills

The TIMEVALUE() Function Knowledgebase

The TIMEVALUE function returns the a time value when given a formatted time.

The syntax for the function is TIMEVALUE (time_text) . The "time_text" must be a string or a recognizable time format in Excel.

Excel can recognize different time formats and converts them into time values.
For example: TIMEVALUE ("13:02:12") = 0.54194444 or TIMEVALUE("6:24:33 PM") = 0.767048611

How to use the TIMEVALUE() function:

Type " =TIMEVALUE( "
Type a quotation mark.
Enter the time "6:24:33"
Type another quotation mark to close the string.
Type ")" then press the "Enter" key.

The TIMEVALUE function does not accept cell coordintes as arguments. To convert a time into a time value the string must be put directly in to the function.

Note: Make sure the cell is formatted as "general". If the cell is formatted as a date the TIMEVALUE function will display a the time as represented by the time value argument or rounded to two decimal places if it is formatted as a number.