Ask Your Question

Revision history [back]

For correct sorting of column with dates/times, you need to have these dates/times to be represented as values, not text strings. Dates and times in Calc internally are represented as numbers (dates) and fractions of the day (time), so you need to correctly prepare data for sorting. For example, today’s noon2019/04/10 12:00 for Calc is a value of 43565.5 It looks like your column has just text strings, not real date/time values, so that is why sorting is performed in alphabetical order, not in numerical one. You can play a bit with values to learn - create new sheet, insert some random values with decimal part in A column, change cell format to YYYY-MM-DD HH:MM or DDD HH:MM and then perform sorting, the result should be as you expected. You can format cell to display weekday, date and time in one cell, but in first place you need to have this cell to hold correct value, not just text.

For correct sorting of column with dates/times, you need to have these dates/times to be represented as values, not text strings. Dates and times in Calc internally are represented as numbers (dates) and fractions of the day (time), so you need to correctly prepare data for sorting. For example, today’s noon2019/04/10 12:00 for Calc is a value of 43565.5 It looks like your column has just text strings, not real date/time values, so that is why sorting is performed in alphabetical order, not in numerical one. You can play a bit with values to learn - create new sheet, insert some random values with decimal part in A column, change cell format to YYYY-MM-DD HH:MM or DDD HH:MM and then perform sorting, the result should be as you expected. You can format cell to display weekday, date and time in one single cell, but in first place you need to have this cell to hold correct value, not just text.