895 votesKim M commented
Agreed! It is a lovely duration in Power Query, so why can't it also appear in Power Pivot?! Need duration that includes: days h:mm:ss and some folks also need the ms on the end. Most of my durations exceed 24 hours, so days is a critical component.