title: Import Excel files with different Date types
body: <p>Got a lot of Excel files, all containing the same columns. One of the columns is called "DateTime". The problem is, that this column contain different formats, e.g:</p>
  
  <pre><code>2/12/2013  11:59:45 PM
  20/2/2013 14:36:58
  </code></pre>
  
  <p>As you can see, the first example contains a PM at the end. Here is my problem: </p>
  
  <p>My code to import all the Excel files in the specific folder: </p>
  
  <pre><code>file.list &lt;- list.files(pattern='*.xlsx')
  df.list &lt;- lapply(file.list, read_excel)
  df &lt;- bind_rows(df.list, .id = "id")
  </code></pre>
  
  <p>But, after I run the second line (<code>df.list &lt;- lapply(file.list, read_excel)</code>) I got a warnings like (Expecting numeric, got a date). </p>
  
  <p>I tried different things, such as assigning <code>col_types = "text"</code> (I hoped that I could import all the data as character, and afterwards change remove the PM at the end and change the characters back to <code>as.Date</code> again). But unfortunately the results was a lot of <code>NA</code>'s. </p>
  
  <p>Another thing that I tried was to import the the file as numeric (but again, received the same message "Expecting numeric, got a date). </p>
  
  <p>So how can I tackle this problem? I can do it by changing the columns type in Excel, but that is not what I want to do (I prefer to do everything in R). </p>
  
  <p><strong>Edit</strong></p>
  
  <p>Some data as requested (after I imported the data into R with as "character" with the lubridate as_date function, as suggested). </p>
  
  <pre><code>Num Date
  1  41277.000601851854
  2  41277.004710648151
  3  41277.004826388889
  4  41277.007372685184
  5  41277.007789351854
  6  41277.007870370369
  7  41277.010335648149
  8  41277.010868055557
  9  41277.013842592591
  10 41277.014548611114
  </code></pre>