In order to sort by times of the 7 days, format the cells to show the day with the week. If you'd like to sort through the day on the week whatever the day, convert them to text by utilizing the TEXT function. Just before sharing, review the macro code https://www.customguide.com/google-sheets/conditional-formatting-google-sheets