Downloads
Power Query MDurationBeginner

Duration.Minutes

Returns the minutes part of a duration, from 0 to 59, after whole hours are taken out.

Syntax
Duration.Minutes(duration as nullable duration) as nullable number

Returns: The minutes part as a number, or null when the input is null.

What it does

Duration.Minutes returns the minutes part of a duration, after the whole hours are removed. A duration of 2 hours and 45 minutes has a minutes part of 45. Use it with Duration.Hours to show elapsed time in hours and minutes, as a close checklist or a reconciliation timing report would.

Syntax and arguments

Example

A controller times the bank reconciliation for the month, from the start of the task to its finish. The timing is shown as hours and minutes for the close log.

let
    Started = #datetime(2026, 10, 29, 9, 15, 0),
    Finished = #datetime(2026, 10, 29, 12, 0, 0),
    Elapsed = Finished - Started,
    Label = Text.From(Duration.Hours(Elapsed)) & " h " & Text.From(Duration.Minutes(Elapsed)) & " min"
in
    Label

The task ran from 9:15 to 12:00, which is 2 hours and 45 minutes. The label reads "2 h 45 min".

Example: a second, different use

Round a duration to the nearest quarter hour for a timesheet by reading the minutes part first.

Things to watch

In business terms

Close timing, approval cycles and billable time are often tracked in minutes. A minutes part that matches the hours part gives the team a readable log of how long each task really took.

Related functions

All Power Query M functions · View as Markdown · M basics