Every so often, people design one cell for a date, and an adjacent cell for the corresponding time, not realizing, that this should be ONE combined value, and then simple formatting does the trick of presenting this the proper way.
(Although format codes for time values is one dangerous area when you're dealing with an international environment.)