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:
Related functions
Category
Date and time