The Excel Timevalue function converts a text representation of a time, into an Excel time. ie. the function converts a text string representing a time, into the decimal value that represents the time in Excel.
Syntax: TIMEVALUE( time_text )
where the time_text argument is a text string representing a time. Within this text string, the hours, minutes and seconds should be separated by colons. 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”). Note also that, if the time_text argument contains a date and time, the Timevalue function ignores the date part of the text string. These rules are illustrated in the examples below.
Timevalue Function Examples
The following spreadsheet shows several examples of the Excel Timevalue function.
In the above example spreadsheet:
- The value in cell A6 is a date and time, and so in this case, the Timevalue function has ignored the date part of the value, and just used the time portion.
- The cells in the results spreadsheet all have the general formatting. These values can be displayed as times by changing the cell formatting. To do this:
The resulting formatted spreadsheet is shown on the right.
Results with time formatting:
Timevalue Function Error
If you get an error from the Excel Timevalue function, this is likely to be the #VALUE! error occurs if the supplied time_text cannot be recognised as a valid Excel time.