Kommentar
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Converts a time in text format to a time in datetime format.
Syntax
TIMEVALUE(time_text)
Parameters
Term |
Definition |
time_text |
A text string that that represents a certain time of the day. Any date information included in the time_text argument is ignored. |
Return Value
A date (datetime).
Remarks
Time values are a portion of a date value and represented by a decimal number. For example, 12:00 PM is represented as 0.5 because it is half of a day.
When the time_text argument is a text representation of the date and time, the function uses the locale and date/time settings of the client computer to understand the text value in order to perform the conversion. Most locales use the colon (:) as the time separator, and any input text using colons as time separators will parse correctly. Review your locale settings to understand your results.
Example
=TIMEVALUE("20:45:30")