title: How to format a duration as HH:mm?
body: <p>In the new Google sheets there's a way of formatting a number as a duration. Format -> Number -> Duration.</p>
  
  <ul>
  <li><code>1</code> is formatted as <code>24:00:00</code></li>
  <li><code>1.2</code> is formatted as <code>28:48:00</code></li>
  <li><code>1.5</code> is formatted as <code>36:00:00</code></li>
  <li><code>0.03125</code> is formatted as <code>0:45:00</code>. </li>
  </ul>
  
  <p>I don't need the seconds in the duration representation, because they bloat my timesheet.</p>
  
  <p>How can I format a duration as HH:mm (without using a formula to calculate hours and minutes and concatenate that with a colon). Is there a way of using the TEXT formula.</p>
  
  <p>This is how I would like it:</p>
  
  <ul>
  <li><code>1</code> is formatted as <code>24:00</code></li>
  <li><code>1.2</code> is formatted as <code>28:48</code></li>
  <li><code>1.5</code> is formatted as <code>36:00</code> (I don't need <code>12:00</code> which datetime-formatting would accomplish)</li>
  <li><code>0.03125</code> is formatted as <code>0:45</code></li>
  </ul>