Time.From is a Power Query M function that converts various input values into a time value, with an optional culture parameter. The function returns a time value derived from the given input value.
Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365
Syntax
Time.From(
value as any,
optional culture as nullable text,
) as nullable time| Argument | Attribute | Description |
|---|---|---|
| value | The value to extract a time value from. | |
| culture | optional | The culture argument enables the specification of a Culture code (e.g., “nl-NL” or “en-US”) to align transformations with local formatting conventions. If this argument is omitted, functions default to Culture.Current, which reflects the system’s regional settings. |
Description
Returns a time value from the given value. An optional culture may also be provided (for example, “en-US”). If the given value is null, Time.From returns null. If the given value is time, value is returned. Values of the following types can be converted to a time value:
text: Atimevalue from textual representation. Refer to Time.FromText for details.datetime: The time component of thevalue.datetimezone: The time component of the local datetime equivalent ofvalue.number: Atimeequivalent to the number of fractional days expressed byvalue. Ifvalueis negative or greater or equal to 1, an error is returned.
If value is of any other type, an error is returned.
Examples
Convert 0.7575 to a time value.
// Output: #time( 18, 10, 48 )
Time.From( 0.7575 )Convert #datetime( 1899, 12, 30, 06, 45, 12 ) to a time value.
// Output: #time( 06, 45, 12 )
Time.From( #datetime( 1899, 12, 30, 06, 45, 12 ) )Related functions
Other functions related to Time.From are:
