How to represent date and time in one excel cell?

Question

How to represent date and time in one excel cell?

There are cell formats such as date and time. But there is no one format that includes both date and time. How should I write both date and time in one cell then?

What I had to do is to split the date and time in two separate cells like this:

Edit: This picture shows how I get a date and the incorrect result I get.

Answer 1

If you enter:

=NOW()

in a cell and format the cell as Custom

dd/mm/yyyy hh:mm:ss

You should get what you want.