TIMEVALUE – Converts Text Value into Excel Time format


TIMEVALUE functions converts a time which is stored as text into a decimal number which is recognized by Excel.

Syntax of TIMEVALUE function in Excel


TIMEVALUE Function in Excel-ExcelBlackBook.com



=TIMEVALUE(“2:50 am”) returns a number 0.118055556 of time.

Function Requirement:

A text string that represents a time in any one of the Microsoft Excel time formats; for example, “6:45 PM” and “18:45” text strings within quotation marks that represent time.

TIMEVALUE helps in converting dates in text format into Excel Date.

More Examples of a TIMEVALUE Function in Excel:

=TIMEVALUE(“2:30 AM”) returns a value of 0.104166667
=TIMEVALUE(“12:50 PM”) returns a value of 0.534722222
=TIMEVALUE(“17:20”) returns a value of 0.722222222

All the Above returns decimal numbers can be changed in the time format by right clicking on the cell and selecting Format Cells and on the number tab, select Time >> type and Save.