title: EXCEL VBA Timevalue format (hh:mm am/pm)
body: <p>How do I set the format for timevalue for 12-hour clock without second. For example: hh:mm AM/PM. Right now I'm using <code>Format(TimeValue(Now), "hh:mm")</code> but it wont display AM/PM. </p>
  
  <p>Thanks in advance.</p>