If you wish to sort by times from the 7 days, format the cells to show the working day of your week. If you want to sort through the day on the 7 days regardless of the day, transform them to text by utilizing the TEXT function. When you prevent https://www.customguide.com/excel/pivot-table-multiple-columns