Updated on

Time.Minute is a Power Query M function that extracts the minute component from a given time, datetime, or datetimezone value. The function returns the minute component as a number.

Compatible with: Power BI Service Power BI Desktop Excel Microsoft 365


Time.Minute( dateTime as any ) as nullable number


Time.Minute returns the minute component of the provided time, datetime, or datetimezone value, dateTime. This function extracts the minute portion from a time-related value and returns it as a number, ranging from 0 to 59.


Find the minute in #datetime( 2011, 12, 31, 9, 15, 36 ).

// Output: 15
Time.Minute( #datetime( 2011, 12, 31, 9, 15, 36 ) )

Other functions related to Time.Minute are:

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