Home » Excel-Built-In-Functions » Excel-Timevalue-Function Search this site: Custom Search

Related Function : DATEVALUE Function

Basic Description

The Excel TIMEVALUE function converts a text string into an Excel time.

- ie. the function converts a string representing a time, into a decimal value (between 0 and 0.99999) that represents the time in Excel.

The format of the Timevalue function is :

where the time_text argument is a text string representing a time.

Within the time_text argument, the hours, minutes and seconds should be separated by colons.

Note that, if just two values are supplied (eg. 02:54), this will be treated as hours and minutes, not minutes and seconds. If you want to represent 2 minutes and 54 seconds, this must be supplied with the hour specified as zero (eg. "00:02:54").

Also note that, if the time_text argument contains a date and time, the Timevalue function ignores the date part of the text string.

Examples

The following spreadsheet shows several examples of the Excel Timevalue function. The format of the function is shown in the spreadsheet on the left and the result is shown in the spreadsheet on the right.

Formatting

There is a good chance that your result from the Excel Timevalue function will initially be displayed as a decimal number (eg. 0.0993). This is because the cell containing the formula is not formatted to show times.

To change the formatting to a time format:

For more details, go to the Excel Formatting page.