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.
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.
During the past 15 years of my contributions to Excel newsgroups, I’ve noticed this question come up a couple times. Not common, one of those “hey look what you can do with date and time in the same cell” items, but not unheard of as a request.
Thanks for your kind words about my postings. I also post half dozen tweets and tips at my social media pages here, all free: