TIMEVALUE

The TIMEVALUE function converts a text-formatted time to a datetime-formatted time.

Syntax

TIMEVALUE(
    time_text
)

Parameters
  • time_text: Text string representing a time.
Returned value

The TIMEVALUE function returns a value in datetime format.

Additional Information

The TIMEVALUE function uses the local date and time setting to interpret the text string to be converted.

If the text string contains date information, it is ignored.

The date included in the result is always December 30, 1899.

Examples

In this example you can check the date that is assigned by default:

TIMEVALUE function. Example of use

Related functions
Category
Date and time
Submitted by admin on Mon, 12/03/2018 - 23:23