If you wish to sort by times on the 7 days, format the cells to show the working day on the 7 days. If you'd like to sort by the day of your week whatever the day, transform them to text by using the TEXT function. Notes: Possible Difficulties Check https://www.customguide.com/excel/find-and-replace-in-excel