title: How do I format Time in [h]:mm excel format using format() function in VBA
body: <p>Is it possible to format time in [h]:mm format using VBA?</p>
  
  <p>[h]:mm format in excel would show 25 hours as 25:00, 125 hours as 125:00</p>
  
  <p>I've tried several things such as:</p>
  
  <pre><code>format(datetime, "[h]:mm")
  format(datetime, "H:mm")
  format(datetime, "hh:mm")
  </code></pre>
  
  <p>None of these have the desired effect. I've also had a look through the MS help and can't find anything useful.</p>