TIMEVALUE (convert text into time)

<< Click to Display Table of Contents >>

TIMEVALUE (convert text into time)

Syntax:

TIMEVALUE(Text)

Description:

Converts a text string representing a date to 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 PlanMaker) automatically convert values into date/time values, where necessary.

Example:

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

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

See also:

DATEVALUE, DATE, TIME