Sort times within specific dates

Copper Contributor

Hi community!  I have a list with dates in one column and times in an adjacent column.  There are multiple entries for a given date, and unique times for events happening on a given day.  Is there a formula I could use to sort the time from earliest to latest, within each day?

date and time.png

1 Reply


If you don't work with Office 365 or Excel 2021 you can follow this instruction.

Sort data in a table - Microsoft Support

Otherwise you can apply SORT or SORTBY according to this example.

SORT and SORTBY with multiple columns | Exceljet