title: Remove seconds in the date-time number in Excel
body: <p>I have a column of date-time numbers, "DD/MM/YY HH:MM:SS". At this moment, I want to remove "SS" from it and left "DD/MM/YY HH:MM". I tried DATE and TIME function separately but only one part left, <code>DATE</code>:"DD/MM/YY" and <code>TIME</code>:"HH:MM", also, I tried <code>CONCATENATE</code> function but it doesn't work, so could anyone do me a favour? Thanks in advance. </p>