Tom’s Tutorials For Excel: Setting Alignments For Date Left and Time Right in a Single Cell

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.





Share Button
Posted in Tom's Tutorials for Excel
Tags: , , , , , , , , , , , , ,
2 comments on “Tom’s Tutorials For Excel: Setting Alignments For Date Left and Time Right in a Single Cell
  1. Melissia Lenox says:

    My coworkers and I have been wracking our brains to come up with a reason one would need or want to left flush date and right flush time values in a cell. We have yet to determine that it saves time or has any value other than appearance of larger visual character separation between the data sets insuite.

    Thank you for the tutorials you provide free of charge – the availibility of dependable excel hacks in your clear and precise manner allows even those less experienced or fluent in excel to produce the intended result(s). I appreciate you and the meaningful effects on all of our skill levels, productivity, and number and duration of happy dances.

Leave a Reply to Melissia Lenox Cancel reply

Your email address will not be published. Required fields are marked *

*