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