Formulas and functions > Functions from A to Z > TIMEVALUE (convert text into time)

Syntax:

TIMEVALUE(Text)

Description:

This converts a text string representing a date into a serial time value.

Note:

This function was retained only for compatibility with older spreadsheet applications. It is no longer commonly used, as current spreadsheet applications (including Calculate) automatically convert times specified as text into date/time values if necessary.

Example:

TIMEVALUE("10:30:00 am") returns 0.4375.

If you now format this using the options of the ribbon tab Home | group Number in one of the date/time formats (for example, h:mm), the cell will display the time behind this value: 10:30.