Question: 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, `DATE`:"DD/MM/YY" and `TIME`:"HH:MM", also, I tried `CONCATENATE` function but it doesn't work, so could anyone do me a favour? Thanks in advance.

Answer: 
Select the cell(s) to be modified and tap `Ctrl`+`1`. Go to the *Number* tab and chose *Custom* from the list down the left. Supply the following for the *Type:*

```
dd/mm/yy hh:mm    ◄ EN-US
pp/kk/vv tt:mm    ◄ FI-FI

```

Click `OK` and you should be set.

    ![Ctrl+1 Custom Number Format](https://i.stack.imgur.com/CiCGz.png)
Try this formula: 

```
Round(CELL * 60 * 24 , 0)/60/24

```