Calculation Issues

Convert Minutes to Days, Hours, and Minutes in Excel Power Pivot DAX

Natalie TaylorNatalie Taylor Nov 14, 2026 868 views

Question details

Convert a numeric minute value in Power Pivot into a display showing total days, hours, and minutes.

Convert Minutes to Days, Hours, and Minutes in Excel Power Pivot DAX
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the data model

In Excel, select Power Pivot > Manage, then select the table containing ResponseTime.

2
Add the DAX formula

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"))

3
Name and check the column

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.

Create a DAX calculated column for the duration
Keep the numeric column for calculations: The formatted result is text, so retain the original minute column for totals, numeric sorting, and further calculations. Blank values display as 00:00:00.
Free Microsoft Office alternative

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.

Use spreadsheet formulas to work with minute-based duration dataOpen and edit Microsoft Excel XLS and XLSX filesNavigate a familiar spreadsheet interfaceMove between Office-compatible files with a lightweight suite
microsoft office alternative - wps office

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.