Convert Minutes to Days, Hours, and Minutes in Excel Power Pivot DAX
Question details
Convert a numeric minute value in Power Pivot into a display showing total days, hours, and minutes.

- Product
- Microsoft Excel Power Pivot
- Device & OS
- not provided
- Scenario
- A Power Pivot data model contains a ResponseTime or ResolutionTime column measured in minutes.
- Observed behavior
- Dividing by 1,440 converts minutes to days, but a calendar date format can show the day of the month instead of the total duration in days.
Confirm that the source column contains nonnegative whole minutes and that Power Pivot is available in Excel. Identify the table and column you want to convert, such as ResponseTime.
Create a DAX calculated column for the duration
Use this approach to display total days followed by two-digit hours and minutes, including durations longer than a month.
The formula calculates days and the remaining hours and minutes separately. It returns text in days:hours:minutes form rather than a numeric duration.
In Excel, select Power Pivot > Manage, then select the table containing ResponseTime.
Select Add Column and enter this formula in the formula bar: =IF(ISBLANK([ResponseTime]), "00:00:00", FORMAT(INT([ResponseTime]/1440), "00") & ":" & FORMAT(INT(MOD([ResponseTime],1440)/60), "00") & ":" & FORMAT(MOD([ResponseTime],60), "00"))
Rename the calculated column, for example Duration, and check a value such as 1,500 minutes: it should display as 01:01:00. Replace each instance of ResponseTime with ResolutionTime if that is the column you need.

Work with duration data in WPS Spreadsheets
WPS Office is a free, lightweight Office alternative with a familiar interface and support for Microsoft Excel files, making it easy to move spreadsheet data between applications. It does not fix Microsoft Power Pivot or its DAX data model.

Frequently Asked Questions
Why does a date format show the wrong number of days?
A date format such as dd:hh:mm can interpret the day component as a calendar day of the month, not the total elapsed days. Calculate total days with INT([ResponseTime]/1440) instead.
How do I convert ResolutionTime instead of ResponseTime?
In Power Pivot > Manage, add the calculated column to the relevant table and replace every instance of [ResponseTime] in the formula with [ResolutionTime].
What happens when the source value is blank?
The IF and ISBLANK parts of the formula return 00:00:00. To show an empty result instead, replace the first "00:00:00" in the formula with an empty string, "".
Can I sum or sort the formatted duration as a number?
The calculated column returns text, so use the original numeric minutes column for summing or numeric sorting. Use the formatted column when you need a readable days:hours:minutes display.




