Time Functions Overview - Power Query How

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	Input	Output
#time	Creates a time value from numbers representing the hour, minute, and (fractional) second.	Number	Time
Time.From	Creates a time from the given value.	Any	Time
Time.FromText	Creates a Time from local and universal, and custom Time formats.	Text	Time
Time.ToRecord	Returns a record containing the Time value’s parts.	Time	Record
Time.ToText	Returns a textual representation of the time value.	Time	Text

Start-End Functions

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

Time Component Functions

Function	Description	Input	Output
Time.Hour	Returns the hour component.	Any	Number
Time.Minute	Returns the minute component.	Any	Number
Time.Second	Returns the second component.	Any	Number

Last update: November 24, 2023 | Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/time-functions
© 2023 BI Gorilla. All rights reserved. Content derived from Microsoft documentation is property of Microsoft Corp.