TIMEVALUE Function in Excel

TIMEVALUE Function in Excel, converts a TIME in text format to a decimal Number that represent particular time in Excel.

Syntax for TIMEVALUE Function in Excel

TIMEVALUE(time_text)

TIMEVALUE Function in Excel takes up time_text as an Argument

NOTE: Excel TIMEVALUE Function Takes up only Text value as Argument, if not #VALUE! Will be returned

Example of TIMEVALUE Function in Excel

Formula:

TIMEVALUE Function in Excel 1

Result:

TIMEVALUE Function in Excel 2

  • Row number 2, 3 and 4 have time in text format, so time value is calculated for them
  • Row number 5 is not in text format so it returns #VALUE!
  • In Row number 6, 7 and 8 time text is passed as input directly, so time value is calculated for them too.

 

Formatting the cells to Display Time

If you want to display the result column in time format then select result column. On Home tab click the dropdown and select time as shown below

TIMEVALUE Function in Excel 3

So the Resultant Formatted table will be

TIMEVALUE Function in Excel 4

previous-small TIMEVALUE Function in Excel                                                                                                                next_small TIMEVALUE Function in Excel