<!-- https://learnsql.cpetoday.com/functions/m/duration-minutes -->
# Duration.Minutes

Language: Power Query M
Category: Duration
Syntax: Duration.Minutes(duration as nullable duration) as nullable number
Summary: Returns the minutes part of a duration, from 0 to 59, after whole hours are taken out.
Returns: The minutes part as a number, or null when the input is null.
Level: Beginner
Related: Duration.Hours, Duration.TotalHours, Duration.Days, Duration.From, DateTime.Time

## 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.

```powerquery
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.
