Table of contents
TOC
Collapse the table of content
Expand the table of content

TIMEVALUE Function (DAX)

Owen Duncan|Last Updated: 4/19/2018

Converts a time in text format to a time in datetime format.

Syntax

TIMEVALUE(time_text)  

Parameters

TermDefinition
time_textA 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")  

See Also

Date and Time Functions (DAX)

© 2018 Microsoft