title: How do I format a Google Sheets duration formatted cell to show days, hours and minutes in a human readable format?
body: <p>The cell I have in Google Sheets currently shows the difference in time between two date-times,  the cell is formatted as a duration and displays as a colon separated value in hours, minutes and seconds.</p>
  <p>Example below.</p>
  <p><code>788:42:07</code></p>
  <p>How do I format the cell to be more human readable, specifically in the format that shows the days, hours and minutes of the duration with each numeric value labelled appropriately?</p>