MINUTE
The minutes past the hour of a date with a time, 0 to 59.
Group: Date and time. Compatible with DAX.
Syntax
MINUTE ( <datetime> )| Parameter | Type | Description |
|---|---|---|
datetime | Date | A date with a time, a time, or text that reads as one. |
Returns
Whole number. The minute within the hour, 0 to 59.
Remarks
- A blank gives BLANK.
- Seconds do not round the minute up: 10:29:59 is minute 29.
- Text such as "14:30" is read as a time.
Examples
Minutes of a few times
EVALUATE
ROW (
"10:29:59", MINUTE ( TIME ( 10, 29, 59 ) ),
"Text", MINUTE ( "14:45" ),
"Date and time", MINUTE ( DATE ( 2024, 3, 15 ) + TIME ( 18, 5, 9 ) )
)| 10:29:59 | Text | Date and time |
|---|---|---|
| 29 | 45 | 5 |