Duration.Minutes
Returns the minutes part of a duration, from 0 to 59, after whole hours are taken out.
Duration.Minutes(duration as nullable duration) as nullable numberReturns: 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
- duration: a duration value, usually the difference between two datetimes.
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
- The minutes part is 0 to 59. For a total in minutes, multiply the total hours from Duration.TotalHours by 60.
- Minutes and hours are separate parts. Keep both when you show elapsed time.
- Seconds are not in this function, so a 2 minute 30 second task shows 2 minutes.
- Null in gives null out.
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.