Cell showing Date but not Time

Question

In my Excel sheet I added the date and time in one cell as below.

At the top (in fx bar) it is showing both the date and time. The problem is, in the cell it is showing only the date but I want both the time and date to be displayed in the cell.

Can anyone help me with this?

Answer 1

Select ColumnB, Home> Cells - Format, Format Cells and under Category: select Custom and in Type: enter dd-mmm-yy hh:mm AM/PM.