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: 
If you want to completely remove the seconds from the data.
Try: `=1*TEXT(C2,"dd/mm/yyyy hh:mm")`

Multiplying the text result by 1 converts the text back to a number.
Try this formula: 

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

```