title: Updating hours with text and dashes in Google Sheets
body: <p>I am trying to figure out how to add +8hours to a schedule formatted with a text in front and a dash in between the hours. Please see example below:</p>
  <p>Training 01:45AM - 02:45AM</p>
  <p>Convert that time to +8 hours.</p>
  <p>Training 09:45AM - 10:45AM.</p>
  <p>I just cant seem to figure out the best formula to use in this scenario.</p>