title: Format times to display with 'AM/PM'
body: <p><img src="https://i.stack.imgur.com/D6MiS.png" alt="Google Spreadsheet"></p>
  
  <p>Normally, when I enter times in Google spreadsheet as <code>22:00:00</code> the display automatically switches to  <code>10:00 PM</code>but sometimes it's not converting.  </p>
  
  <p>How can I set a common format for times in Google spreadsheet? I need this format: <code>8:00 PM</code>.</p>