PDA

View Full Version : Power query - add time to date



wannes
2016-12-02, 09:14 PM
<p style="border: none; font-family: &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, Verdana, Arial, Helvetica, sans-serif; margin-bottom: 1em; outline: 0px; list-style-type: none; color: rgb(51, 51, 51); font-size: 14px;">I have a column with a date and a column with a time.</p><p style="border: none; font-family: &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, Verdana, Arial, Helvetica, sans-serif; margin-bottom: 1em; outline: 0px; list-style-type: none; color: rgb(51, 51, 51); font-size: 14px;">Ie: 11/27/2016 &nbsp;| &nbsp;11:48:14</p><p style="border: none; font-family: &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, Verdana, Arial, Helvetica, sans-serif; margin-bottom: 1em; outline: 0px; list-style-type: none; color: rgb(51, 51, 51); font-size: 14px;">I want to add a column that contains the sum of the date and the time: 11/27/2016 11:48:14.</p><p style="border: none; font-family: &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, Verdana, Arial, Helvetica, sans-serif; margin-bottom: 1em; outline: 0px; list-style-type: none; color: rgb(51, 51, 51); font-size: 14px;">What would be the best syntax to perform that?</p><p style="border: none; font-family: &quot;Segoe UI&quot;, &quot;Lucida Grande&quot;, Verdana, Arial, Helvetica, sans-serif; margin-bottom: 1em; outline: 0px; list-style-type: none; color: rgb(51, 51, 51); font-size: 14px;">Thanks!</p>

Pecoflyer
2016-12-03, 09:04 AM
Unreadable content - Closed