If you want to sort by times in the week, format the cells to show the working day with the week. If you would like sort through the working day on the 7 days whatever the date, transform them to text by using the TEXT function. This chance is particularly https://www.customguide.com/excel/pivot-table-excel