If you would like sort by times of the 7 days, format the cells to show the working day from the 7 days. If you need to sort through the working day on the 7 days regardless of the day, convert them to text by utilizing the TEXT function. Being https://www.customguide.com/excel/how-to-unhide-columns-in-excel