Tom’s Tutorials For Excel: Setting Alignments For Date Left and Time Right in a Single Cell
If you have the date and time in a single cell, such as when you enter the
NOW function, you can custom format the cell as
MMM D, YYYY * H:MM AM/PM to separate the date (flush left inside the cell), and the time (flush right inside the cell). Notice the asterisk in the format statement that causes the visual separation in the cell of the date and time portions.