If you want to sort by times from the 7 days, format the cells to show the day with the week. If you need to sort with the working day on the 7 days regardless of the day, transform them to text by using the TEXT function. This method delivers https://www.customguide.com/excel/absolute-reference-excel