title: Convert DateTime format in epplus
body: <p>I want to read a column from excel into datatable using epplus but whenever i do I get the time in 24 hour format. I want the time to be in 12 hour format as it is in excel.</p>
  
  <p>I have tried changing the date format of excel to "dd/mm/yyyy hh:mm:ss tt" it give me AM/PM but it shows the time in 24 hour format.</p>
  
  <pre><code>worksheet.Cells["" + firstRowCell.Address + ":" + 
  Regex.Replace(firstRowCell.Address, "[0-9]", "") + "" + 
  worksheet.Dimension.Rows].Style.Numberformat.Format =  "dd/mm/yyyy hh:mm:ss tt";
  </code></pre>