Would like a simple method to format cells to display both Date & Time.
Currently a date format and time format, but no date-time format, such as yyyy-MM-dd HH:mm:ss.
I waste so much time with custom formats since I more often that not am interested in date and time.
GEORGE METCALF commented
display the time in one cell
I frequently need date time to the second, often I am pasting database results into Excel to do some analysis or comparison. Every time, the default format is to show only time, and I have to go into custom formatting.It wastes a LOT of time
It would be good if the list of predefined formats were customisable. Currently I have Short Date, Long Date and Time. I rarely want Long Date but frequently want Short Date and Time. Even if I need to set up the custom formats myself at least it will be there the next time I open Excel rather than having to dig into the custom formats every time.
Also, I cannot see a format that has both date and time in either the Date category or the Time category, I need to go into the Custom category and hunt around for an existing format or type it in manually.
Under the Date Category (in number formatting) , there is already a mm/dd/yyyy hh:mm PM format which might work for you instead of creating a custom format. Same in the Time category.