title: Excel Time Format
body: <p>Having trouble with time formatting.</p>
  
  <p>I have set the cell to custom format 00:00.</p>
  
  <p>Currently in column A a date is inputted, this can be as 0300 which converts to 03:00 which is perfect or you can just enter 03:00.</p>
  
  <p>I now have a problem if a user enters 03;00 as i need this to display 03:00</p>
  
  <p>how can i ensure that all times are in the hh:mm format and not in hh;mm etc.</p>
  
  <p>This needs to auto change on input for anything in column A, except what is the header (A1:A5) although this should not be affected.</p>
  
  <p>Thanks</p>