Time Functions Overview | Power Query M

Explore Time Functions in Power Query M Language, vital for handling time values. This page provides a comprehensive list and descriptions of Time Functions available in the M Language.

Creation and Conversion Functions

Function	Description
#time	Creates a time value from numbers representing the hour, minute, and (fractional) second.
Time.From	Creates a time from the given value.
Time.FromText	Creates a Time from local and universal, and custom Time formats.
Time.ToRecord	Returns a record containing the Time value’s parts.
Time.ToText	Returns a textual representation of the time value.

Start-End Functions

Function	Description
Time.EndOfHour	Returns the end of the hour.
Time.StartOfHour	Returns the start of the hour.

Time Component Functions

Function	Description
Time.Hour	Returns the hour component.
Time.Minute	Returns the minute component.
Time.Second	Returns the second component.

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/time-functions