title: Custom Format for Time in VBA msgbox
body: <p>I am facing a problem with VBA.</p>
  
  <p>I am trying to display a msgbox that contains a DATE, however I only want to display the time as "hh:mm".</p>
  
  <p>I am writing the following in my code to try and apply the needed format:</p>
  
  <blockquote>
    <p>sum1 = Format(ThisCell, "h:mm")</p>
  </blockquote>
  
  <p>sum1 is defined as a DATE and ThisCell as a Range.
  The format displayed in the msgbox is hh:mm AM/PM.</p>
  
  <p>I have searched thoroughly to find a way to do it, but I could not find a way.</p>
  
  <p>Any thoughts or advice is much appreciated.</p>
  
  <p>Have a good day.</p>