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 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:

Result:

• 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

So the Resultant Formatted table will be